1weeks_practice

Tables (4)

mission (Untitled3)

  • PK (id) — int — Primary key — NOT NULL
  • (store_id) — int
  • (title) — varchar(20)
  • (reward_points) — int
  • (created_at) — datetime(6)
  • (update_at) — datetime(6)
  • FK (user_id) — int — Foreign key → user.PK — NOT NULL

mission_assignment (Untitled4)

  • PK (id) — int — Primary key — NOT NULL
  • FK (mission_id) — int — Foreign key → mission.PK — NOT NULL
  • FK (user_id) — int — Foreign key → user.PK — NOT NULL
  • (created_at) — datatime(6)
  • (updated_at) — datatime(6)

user (Untitled)

  • PK (id) — int — Primary key — NOT NULL
  • (email) — varchar(50)
  • (phone_num) — varchar(11)
  • (name) — varchar(30)
  • (created_at) — datetime(6)
  • (updated_at) — datetime(6)

user_login (Untitled2)

  • PK (user_id) — int — Foreign key → user.PK — NOT NULL
  • (password) — int
  • (created_at) — datatime(6)
  • (updated_at) — datetime(6)