Closed shj0212 closed 1 year ago
CREATE TABLE testdb.post ( id BIGINT AUTO_INCREMENT PRIMARY KEY COMMENT '포스트 아이디', title VARCHAR(500) COMMENT '제목', user_id BIGINT COMMENT '작성자', exhibition_id BIGINT COMMENT '전시장 (exhibition id 외래키)', start_date DATETIME COMMENT '시작일', end_date DATETIME COMMENT '종료일', viewing_time VARCHAR(50) COMMENT '관람시간', age_restriction VARCHAR(50) COMMENT '관람연령', price INT COMMENT '정가', summary VARCHAR(500) COMMENT '요약', description TEXT COMMENT '설명', origin_url VARCHAR(500) COMMENT '전시 소개가 자세히 적힌 URL', is_eligibility INT COMMENT '예매 가능 여부', eligibility_date DATETIME COMMENT '티켓 오픈일, 예매 시작일', reg_date DATETIME COMMENT '포스트 등록일', post_url VARCHAR(500) COMMENT '포스트 URL', foreign key (exhibition_id) references exhibition(id), FOREIGN KEY (user_id) REFERENCES users(id) ) COMMENT '전시회 게시물';
ALTER TABLE post ADD COLUMN title VARCHAR(500) COMMENT '제목' AFTER id;
[문제]
[해결]
[결론]