team8

Tables (8)

BOARD

  • BOARD_NO — INT — Primary key — NOT NULL
  • WRITER_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • TITLE — VARCHAR
  • CONTENT — TEXT
  • REG_DATE — DATETIME
  • HIT — INT
  • MOVIE_TITLE (MOVE_TITLE) — VARCHAR
  • MOVIE_POSTER — VARCHAR
  • RATING — INT
  • COMMENT_COUNT — INT
  • LIKE_COUNT — INT
  • REPORT_COUNT — INT

BOARD_LIKES

  • USER_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • BOARD_NO — INT — Foreign key → BOARD.BOARD_NO — NOT NULL

BOARD_REPORTS

  • USER_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • BOARD_NO — INT — Foreign key → BOARD.BOARD_NO — NOT NULL
  • REPORT_DATE — DATETIME

COMMENTS

  • C_NO — INT — Primary key — NOT NULL
  • WRITER_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • BOARD_NO — INT — Foreign key → BOARD.BOARD_NO — NOT NULL
  • CONTENT — TEXT
  • REG_DATE — DATETIME

NO_SPOIL_ZONE

  • Z_NO — INT — Primary key — NOT NULL
  • USER_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • TITLE — VARCHAR
  • RELEASE_YEAR — VARCHAR
  • REG_DATE — DATETIME

SYSTEM_LOGS

  • ID — INT — Primary key — NOT NULL
  • LOG_TIME — TIMESTAMP
  • LEVEL — VARCHAR
  • MESSAGE — VARCHAR

USERS

  • Key (USER_ID) — VARCHAR — Primary key — NOT NULL
  • PASSWORD — VARCHAR
  • NAME — VARCHAR
  • PHONE — VARCHAR
  • NICKNAME — VARCHAR
  • EMOJI — VARCHAR
  • ROLE — VARCHAR
  • JOIN_DATE — TIMESTAMP
  • LAST_MODIFIED — TIMESTAMP

USER_LIKE

  • LIKER_ID — VARCHAR — Primary key
  • CRITIC_ID — VARCHAR — Foreign key → USERS.Key — NOT NULL
  • LIKE_DATE — TIMESTAMP