team_bottari

Tables (9)

alarm (Untitled4)

  • id — bigint — Primary key — NOT NULL

member (Untitled)

  • 아이디 (id) — bigint — Primary key — NOT NULL
  • ssaid — String
  • 이름 (name) — String

team_assigned_item (CopyOfCopyOfUntitled62)

  • id (Key) — bigint — Primary key — NOT NULL
  • 전체 체크여부 (Field2) — boolean
  • 팀 보따리 담당 아이템 (Key2) — bigint — Foreign key → team_assigned_item_info.id — NOT NULL
  • 팀 멤버 보따리 (id) — team_member_bottari_id — Foreign key → team_member.id — NOT NULL

team_assigned_item_info (CopyOfUntitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • 이름 (Field) — String
  • 팀 보따리 (id) — bigint — Foreign key → team_bottari.id — NOT NULL

team_bottari (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • 제목 (title) — String
  • 초대코드 (invite_code) — String
  • 방장 (owner_id) — bigint — Foreign key → member.아이디 — NOT NULL

team_member (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • 팀 보따리 (team_bottari_id) — Long — Foreign key → team_bottari.id — NOT NULL
  • 팀 멤버 (member_id) — Long — Foreign key → member.아이디 — NOT NULL
  • 알람 (alarm_id) — Long — Foreign key → alarm.id — NOT NULL

team_personal_item (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • 이름 (Field) — String
  • 체크여부 (Field2) — boolean
  • 팀 멤버 보따리 (id) — bigint — Foreign key → team_member.id — NOT NULL

team_shared_item (CopyOfUntitled62)

  • id (Key) — bigint — Primary key — NOT NULL
  • 체크여부 (Field2) — boolean
  • 팀 보따리 공통 아이템 (Key2) — bigint — Foreign key → team_shared_item_info.id — NOT NULL
  • 팀 멤버 보따리 (id) — team_member_bottari_id — Foreign key → team_member.id — NOT NULL

team_shared_item_info (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • 이름 (Field) — String
  • 팀 보따리 (id) — bigint — Foreign key → team_bottari.id — NOT NULL