CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, email VARCHAR(89) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT NOW(), nickname VARCHAR(50) UNIQUE );
CREATE TABLE users ( id INT PRIMARY KEY AUTO_INCREMENT, email VARCHAR(89) NOT NULL UNIQUE, password VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT NOW(), nickname VARCHAR(50) UNIQUE );
CREATE TABLE teacher ( id int PRIMARY KEY AUTO_INCREMENT, user_id int NOT NULL, tcr_name varchar(50) NOT NULL, tcr_info TEXT, FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE );
CREATE TABLE course ( id int PRIMARY KEY AUTO_INCREMENT, tcr_id int NOT NULL, crs_name VARCHAR(50) NOT NULL, crs_info TEXT,
thumbnail TEXT, FOREIGN KEY (tcr_id) REFERENCES teacher(id) ON UPDATE CASCADE );
CREATE TABLE lecture ( id int PRIMARY KEY AUTO_INCREMENT, crs_id int NOT NULL, lctr_name varchar(50) not null, lctr_source TEXT not null, lctr_info TEXT, foreign key(crs_id) references course(id) on update cascade );
CREATE TABLE review ( id int primary key auto_increment, user_id int not null, crs_id int not null, start tinyint not null, content text not null, created_at timestamp not null DEFAULT NOW(), updated_at timestamp, foreign key (crs_id) references course(id) on update cascade, foreign key (user_id) references user(id) on update cascade );
INSERT INTO course (crs_name, crs_info,thumbnail) VALUES ('장판', '장판 강의 설명','https://projectlmsfiles.s3.ap-northeast-2.amazonaws.com/images/thumbnail/course1.png');
INSERT INTO course (crs_name, crs_info,thumbnail) VALUES ('마루', '마루 강의 설명','https://projectlmsfiles.s3.ap-northeast-2.amazonaws.com/images/thumbnail/course2.png');
===============
