study TABLE 컬럼 설명
Table 생성 SQL 문
CREATE TABLE `sitedb`.`study` (
id BIGINT(20) NOT NULL AUTO_INCREMENT,
title VARCHAR(50) NOT NULL,
user_id BIGINT(20) NOT NULL,
maxman INT NOT NULL,
nowman INT DEFAULT 1,
create_date DATETIME DEFAULT NOW(),
description TEXT NOT NULL,
place TEXT NOT NULL,
warn_cnt INT DEFAULT 0,
category VARCHAR(50),
isactive BOOLEAN DEFAULT 1,
PRIMARY KEY (id),
FOREIGN KEY (user_id) REFERENCES user (id) ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE=InnoDB
DEFAULT CHARSET=utf8
COLLATE=utf8_general_ci;
SQL
복사