WhenWhen

Tables (7)

Role(Enum) (CopyOfUntitled2)

  • user (Field)
  • admin (Field2)

availability(Enum) (Untitled2)

  • possible (Field)
  • impossible (Field2)
  • adjustable (Field3)

join (CopyOfCopyOfMember2)

  • id (Key3) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • plan_id (Key4) — Foreign key → plan.id — NOT NULL

join_info (Untitled)

  • id (Key) — Primary key — NOT NULL
  • join_id (Key3) — Foreign key → join.id — NOT NULL
  • datetime (Field)
  • decision (Field2)

personal_schedule (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field)
  • datetime (Field2)

plan

  • id (Key) — Primary key — NOT NULL
  • host_id (Key2) — Foreign key → user.id — NOT NULL
  • title (Field)
  • start_date (Field2)
  • end_date (Field3)
  • expected_member_cnt (Field4)
  • created_datetime (Field6)

user (Member)

  • id (Key) — Primary key — NOT NULL
  • role (Field)