dummy
Tables (4)
Category (카테고리)
- category_id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(255)
Comment (댓글)
- comment_id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
- content (Field) — text
Member (유저)
- member_id (Key) — bigint — Primary key — NOT NULL
- email (Field) — varchar(255)
- password (Field2) — varchar(255)
- birth (Field3) — datetime
Post (게시물)
- post_id (Key) — bigint — Primary key — NOT NULL
- comment_id (Key3) — bigint — Foreign key → Comment.comment_id — NOT NULL
- member_id (Key2) — bigint — Foreign key → Member.member_id — NOT NULL
- category_id (Key4) — bigint — Foreign key → Category.category_id — NOT NULL
- title (Field) — varchar(255)
- content (Field2) — text