bulletin board
Tables (4)
comment (Untitled2)
- comment_id (Key2) — Primary key — NOT NULL
- board_id (Key) — Foreign key → post.post_id — NOT NULL
- member_id (Key3) — Foreign key → member.member_id — NOT NULL
- content (Field2)
- created_datetime (Field3)
- last_modified_datetime (Field4)
- is_shown (Field)
member (Untitled3)
- member_id (Key) — Primary key — NOT NULL
- id (Field)
- password (Field2)
- refresh_token (Field3)
- expires_at (Field4)
post (Untitled)
- post_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- title (Field)
- content (Field2)
- created_datetime (Field3)
- last_modified_datetime (Field4)
- is_shown (Field5)
- like (Field6)
post_like (Untitled4)
- post_like_id (Key3) — Primary key — NOT NULL
- post_id (Key) — Foreign key → post.post_id — NOT NULL
- member_id (Key2) — Foreign key → post.member_id — NOT NULL