sqld
Tables (4)
board (Untitled2)
- board_id (Key) — INT — Primary key — NOT NULL
- title (Field) — VARCHAR(500)
- content (Field2) — VARCHAR(1000)
- createdAt (Field3) — DATE
- updatedAt (Field4) — DATE
- hit (Field5) — INT
- user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
comment (Untitled)
- c_id (Key) — INT — Primary key — NOT NULL
- content (Field) — VARCHAR(500)
- board_id (Key2) — INT — Foreign key → board.board_id — NOT NULL
- user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL
like (Untitled4)
- like_id (Key) — INT — Primary key — NOT NULL
- board_id (Key2) — INT — Foreign key → board.board_id — NOT NULL
- user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL
user (Untitled3)
- user_id (Key) — INT — Primary key — NOT NULL
- u_name (Field) — VARCHAR(15)
- u_nickname (Field2) — VARCHAR(15)
- u_joinedAt (Field3) — DATE
- u_mobile (Field4) — VACRHAR(15)
- u_email (Field5) — VARCHAR(50)