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