Homework
Tables (8)
Copy Of Untitled (OneTimeTask)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (execution_completed) — bit(1) — NOT NULL
- Field (do_date) — datetime — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (difficulty) — varchar(255) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (deleted_at) — datetime — NOT NULL
Untitled (Member)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (usre_id) — bigint(20) — Foreign key → User.Key — NOT NULL
- Key (home_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (system_alert_activated) — bit(1) — NOT NULL
- Field (request_activated) — bit(1) — NOT NULL
- Field2 (created_at) — datetime — NOT NULL
- Field3 (updated_at) — datetime — NOT NULL
- Field4 (deleted_at) — datetime — NOT NULL
- Field5 (activity_point) — int(11) — NOT NULL
Untitled (Home)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (initial_setting_completed) — bit(1) — NOT NULL
Untitled (Category)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (home_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
Untitled (TaskGroup)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (category_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (difficulty) — varchar(255) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (cycle) — int(11) — NOT NULL
- Field (repeat_completed) — bit(1) — NOT NULL
- Field (do_dates) — varchar(255) — NOT NULL
- Field (deleted_at) — bit(1)
- Field (setting_completed) — bit(1) — NOT NULL
Untitled (Task)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (task_group_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(255) — NOT NULL
- Field (request_completed) — bit(1) — NOT NULL
- Field (execution_completed) — bit(1) — NOT NULL
- Field (do_date) — datetime — NOT NULL
Untitled (Message)
- Key (id) — bigint(20) — Primary key — NOT NULL
- Key (sender_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Key (receiver_id) — bigint(20) — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(255) — NOT NULL
- Field (content) — longtext — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (request_state) — varchar(255) — NOT NULL
- Field (read_check) — bit(1) — NOT NULL
User
- Key (id) — bigint(20) — Primary key — NOT NULL
- Field (user_name) — varchar(255) — NOT NULL
- Field2 (profile_image) — varchar(255) — NOT NULL
- Field3 (created_at) — varchar(255) — NOT NULL