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