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`