QMR
Tables (8)
BLOCK
- block_Id — INT — Primary key — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- created_At — DATETIME — NOT NULL
BOARD
- board_Id — INT — Primary key — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- contents — TEXT — NOT NULL
- hashtag — VARCHAR(50)
- created_At — DATETIME — NOT NULL
COMMENT
- comment_Id — INT — Primary key — NOT NULL
- board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- contents — TEXT — NOT NULL
- created_At — DATETIME — NOT NULL
FILE
- file_Id — INT — Primary key — NOT NULL
- board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
- file_Name — VARCHAR(255) — NOT NULL
- file_Type — VARCHAR(255) — NOT NULL
- file_Path — VARCHAR(255) — NOT NULL
- created_At — DATETIME — NOT NULL
FOLLOW
- follow_Id — INT — Primary key — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- created_At — DATETIME — NOT NULL
LIKE
- like_Id — INT — Primary key — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- board_id — INT — Foreign key → BOARD.board_Id — NOT NULL
- created_At — DATETIME — NOT NULL
SHARE
- share_Id — INT — Primary key — NOT NULL
- user_Id — INT — Foreign key → USER.user_Id — NOT NULL
- board_Id — INT — Foreign key → BOARD.board_Id — NOT NULL
- created_At — DATETIME — NOT NULL
USER
- user_Id — INT — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- birthday — DATE — NOT NULL
- created_At — DATETIME — NOT NULL