moyeobwayo

Tables (6)

alarm (Untitled)

  • alarm_id (key) — int — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → user_entity.user_id — NOT NULL
  • party_id (Key4) — string — Foreign key → party.party_id — NOT NULL
  • party_id (Key2) — string — Foreign key → user_entity.party_id — NOT NULL
  • alarm_on (Field) — boolean

date_entity (Untitled8)

  • date_id (Key) — int — Primary key — NOT NULL
  • party_id (Key2) — string — Foreign key → party.party_id — NOT NULL
  • selected_date (Field) — date

kakao_profile (Untitled4)

  • kakao_user_id (Key) — int — Primary key — NOT NULL
  • profile_image (Field)
  • nickname (Field2) — string
  • kakao_id (Field3) — string
  • alarm_off (Field4) — bool

party (Untitled3)

  • party_id (Key) — string — Primary key — NOT NULL
  • target_num (Field4) — int
  • current_num (Field3) — int
  • party_name (Field) — string
  • party_description (Field6) — string
  • start_date (Field2) — date
  • end_date (Field5) — date
  • decision_date (Field7) — date

timeslot (Untitled9)

  • slot_id (Key) — int — Primary key — NOT NULL
  • date_id (Key2) — int — Foreign key → date_entity.date_id — NOT NULL
  • user_id (Key3) — int — Foreign key → user_entity.user_id — NOT NULL
  • party_id (Key22) — string — Foreign key → user_entity.party_id — NOT NULL
  • selected_start_time (Field) — date
  • selected_end_time (Field2) — date
  • biString (Field3) — string

user_entity (Untitled7)

  • user_id (Key) — int — Primary key — NOT NULL
  • kakao_user_id (Key3) — int — Foreign key → kakao_profile.kakao_user_id — NOT NULL
  • party_id (Key2) — string — Foreign key → party.party_id — NOT NULL
  • user_name (Field) — string
  • password (Field2) — string