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