toy
테이블 (9)
Untitled (member_role)
- Key (member_role_id) — bigint — 기본 키 — NOT NULL
- Key (member_id) — bigint — 외래 키 → 회원.Key — NOT NULL — unique_1
- Key (role_id) — bigint — 외래 키 → 권한.Key — NOT NULL — unique_1
Untitled (post)
- Key (post_id) — bigint — 기본 키 — NOT NULL
- Key (member_id) — bigint — 외래 키 → 회원.Key — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field (content) — varchar(255) — NOT NULL
Untitled (comment)
- Key (comment_id) — bigint — 기본 키 — NOT NULL
- Key (parent_comment_id) — bigint — 외래 키 → Untitled.Key
- Key (post_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Key (member_id) — bigint — 외래 키 → 회원.Key — NOT NULL
- Field (content) — varchar(255) — NOT NULL
Untitled (login_type)
- Key (login_type_id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(255) — NOT NULL — unique
Untitled (post_image)
- Key (post_image_id) — bigint — 기본 키 — NOT NULL
- Key (post_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (image_src) — varchar(255) — NOT NULL
Untitled (post_like)
- Key (post_like_id) — bigint — 기본 키 — NOT NULL
- Key (post_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — unique_1
- Key (member_id) — bigint — 외래 키 → 회원.Key — NOT NULL — unique_1
- Field (is_like) — boolean — NOT NULL
Untitled (comment_like)
- Key (comment_like_id) — bigint — 기본 키 — NOT NULL
- Key (comment_id) — bigint — 외래 키 → Untitled.Key — NOT NULL — unique_1
- Key (member_id) — bigint — 외래 키 → 회원.Key — NOT NULL — unique_1
- Field (is_like) — boolean — NOT NULL
권한 (role)
- Key (role_id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(255) — NOT NULL — unique_1
회원 (member)
- Key (member_id) — bigint — 기본 키 — NOT NULL
- Key (login_type_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
- Field (email) — varchar(255) — NOT NULL — unique_1
- Field (password) — varchar(255) — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (image_src) — varchar(255) — NOT NULL