Helpromise

Tables (10)

Users (Untitled)

  • id — char — Primary key — NOT NULL
  • pw — char
  • address — char
  • Field3
  • Field4
  • Field5
  • Field6

board (Untitled6)

  • id — int — Primary key — NOT NULL
  • date — datetime
  • userid — char — Foreign key → Users.id — NOT NULL
  • content — char
  • Field

day_schedules (Untitled10)

  • id — int — Primary key — NOT NULL
  • content — char
  • name — char
  • start_time — datetime
  • end_time — datetime
  • Field
  • user_schedules_id — int — Foreign key → user_schedules.id — NOT NULL

department (Untitled5)

  • id — int — Primary key — NOT NULL
  • name — char
  • Field

favorite_user (Untitled7)

  • id — Primary key — NOT NULL
  • favorite_user_id — char
  • userid — char — Foreign key → Users.id — NOT NULL

group (Untitled4)

  • groupid — int — Primary key — NOT NULL
  • userid — char — Foreign key → Users.id — NOT NULL
  • departid — int — Foreign key → department.id — NOT NULL

group_day_schedules (Untitled11)

  • id — int — Primary key — NOT NULL
  • content — char
  • group_schedules_id — int — Foreign key → group_schedules.id — NOT NULL
  • name — char
  • start_time — datetime
  • end_time — datetime
  • Field

group_schedules (Untitled3)

  • id — int — Primary key — NOT NULL
  • departid — int — Foreign key → department.id — NOT NULL
  • date — datetime

schedules_alarm (Untitled9)

  • id — int — Primary key — NOT NULL
  • content — char
  • user_schedules_id — int — Foreign key → day_schedules.id — NOT NULL
  • group_schedule_id — int — Foreign key → group_day_schedules.id — NOT NULL
  • push_date — datetime
  • Field

user_schedules (Untitled2)

  • id — int — Primary key — NOT NULL
  • date — datetime
  • userid — char — Foreign key → Users.id — NOT NULL
  • to-do — char — NOT NULL