culife
Tables (14)
alert
- no — INT — Primary key — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- content — LONGTEXT — NOT NULL
- create_date — DATETIME — NOT NULL
- check — INT — NOT NULL
- INDEX — `fk_alert_member1_idx`
author
- no — INT — Primary key — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- author — VARCHAR(45) — NOT NULL
- sns_link — VARCHAR(45) — NOT NULL
- author_thumbnail — VARCHAR(45) — NOT NULL
- debut_year — INT — NOT NULL
- create_date — DATETIME — NOT NULL
- author_status — INT
- msg — VARCHAR(100)
- author_msg — VARCHAR(100) — NOT NULL
- INDEX — `fk_author_apply_member1_idx`
author_fan
- member_no — INT — Foreign key → member.no — NOT NULL
- author_no — INT — Foreign key → author.no — NOT NULL
- create_date — DATETIME — NOT NULL
- INDEX — `fk_author_fan_author1_idx`
board
- no — INT — Primary key — NOT NULL
- subject — VARCHAR(300) — NOT NULL
- content — LONGTEXT — NOT NULL
- write_date — DATETIME — NOT NULL
- view — INT — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- category — VARCHAR(45) — NOT NULL
- INDEX — `fk_board_member1_idx`
board_reply
- reply_no — INT — Primary key — NOT NULL
- no — INT — Foreign key → board.no — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- content — VARCHAR(300) — NOT NULL
- write_date — DATETIME — NOT NULL
- INDEX — `fk_board_reply_board1_idx`
- INDEX — `fk_board_reply_member1_idx`
exhibition
- no — INT — Primary key — NOT NULL
- author_no — INT — Foreign key → author.no — NOT NULL
- subject — VARCHAR(45) — NOT NULL
- content — LONGTEXT — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- create_date — DATETIME — NOT NULL
- type — INT — NOT NULL
- INDEX — `fk_exhibition_author1_idx`
exhibition_reply
- no — INT — Primary key — NOT NULL
- exhibition_no — INT — Foreign key → exhibition.no — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- content — VARCHAR(45) — NOT NULL
- write_date — DATETIME — NOT NULL
- INDEX — `fk_exhibition_reply_exhibition1_idx`
- INDEX — `fk_exhibition_reply_member1_idx`
m_warning
- member_no — INT — Foreign key → member.no — NOT NULL
- review_no — INT — Foreign key → movie_review.no — NOT NULL
- warning_date — DATETIME — NOT NULL
- INDEX — `fk_m_warning_movie_review1_idx`
member
- no — INT — Primary key — NOT NULL
- kakao_id — BIGINT — NOT NULL
- email — VARCHAR(45) — NOT NULL
- nickname — VARCHAR(45) — NOT NULL
- grade — INT — NOT NULL
- warning_count — INT — NOT NULL
- thumbnail — LONGTEXT
- status — INT — NOT NULL
- create_date — DATETIME — NOT NULL
member_ban
- no — INT — Primary key — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- start_date — DATETIME
- end_date — DATETIME
- INDEX — `fk_member_ban_member1_idx`
movie_review
- no — INT — Primary key — NOT NULL
- movie_id — INT — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- movie_title — VARCHAR(45) — NOT NULL
- content — LONGTEXT — NOT NULL
- score_star — INT — NOT NULL
- poster_path — VARCHAR(45) — NOT NULL
- vote_count — INT — NOT NULL
- write_date — DATETIME — NOT NULL
- spo_check — INT — NOT NULL
- INDEX — `fk_movie_review_member1_idx`
review
- no — INT — Primary key — NOT NULL
- title — VARCHAR(45) — NOT NULL
- member_no — INT — Foreign key → member.no — NOT NULL
- content — LONGTEXT — NOT NULL
- score_star — INT — NOT NULL
- write_date — DATETIME — NOT NULL
- spo_check — INT — NOT NULL
- poster — VARCHAR(200) — NOT NULL
- seq — INT — NOT NULL
- INDEX — `fk_review_member1_idx`
warning
- member_no — INT — Foreign key → member.no — NOT NULL
- review_no — INT — Foreign key → review.no — NOT NULL
- warning_date — DATETIME — NOT NULL
- INDEX — `fk_warning_review1_idx`
work
- no — INT — Primary key — NOT NULL
- exhibition_no — INT — Foreign key → exhibition.no — NOT NULL
- work_subject — VARCHAR(45) — NOT NULL
- work_thumbnail — VARCHAR(45) — NOT NULL
- work_content — LONGTEXT — NOT NULL
- write_date — DATETIME — NOT NULL
- INDEX — `fk_work_exhibition1_idx`