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