CallbusLab Community

Tables (4)

AccountType (계정 타입)

  • account_id — Enum — Primary key — NOT NULL

Member (회원)

  • id (member_id) — Long — Primary key — NOT NULL
  • account_id — AccountType — Foreign key → AccountType.account_id — NOT NULL
  • nickname (member_nickname) — String
  • password (member_password) — String
  • account_id (member_account_id) — Long
  • quit (member_quit) — boolean

Post (글)

  • id (post_id) — Long — Primary key — NOT NULL
  • member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • title (post_title) — String
  • content (post_content) — String
  • visible (post_visible) — boolean
  • deleteDate (delete_date) — LocalDateTime
  • account_id (account_id2) — AccountType — Foreign key → Member.account_id — NOT NULL

like (좋아요)

  • like (like_id) — Long — Primary key — NOT NULL
  • member (member_id) — Long — Foreign key → Member.id — NOT NULL
  • post (post_id) — Long — Foreign key → Post.id — NOT NULL
  • account_id (account_id2) — AccountType — Foreign key → Member.account_id — NOT NULL