실습

테이블 (5)

Login

  • user_id — varchar(50) — 기본 키 — NOT NULL
  • Field (user_name) — varchar(50)
  • Field2 (email) — varchar(100)
  • Field (password) — varchar(255)
  • Field (login_date) — timestamp

Untitled (Join)

  • user_id — varchar(50) — 외래 키 → Login.user_id — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (gender) — bigint — NOT NULL
  • Field (user_name) — varchar(50) — NOT NULL
  • Field (password) — varchar(50) — NOT NULL
  • Field (address_post) — varchar(50) — NOT NULL
  • Field (address_room_number) — varchar(50) — NOT NULL
  • Field

Untitled (food_preference)

  • Key (user_id) — varchar(50) — 기본 키 — NOT NULL
  • user_id (prefer_food) — varchar(50) — 외래 키 → Untitled.user_id — NOT NULL

missions

  • mission_id (mission_name) — varchar(100) — 기본 키 — NOT NULL
  • mission_id — bigint — 외래 키 → user_home_missions.mission_id — NOT NULL
  • description — TEXT
  • Field (status) — int — 1이면 성공, 0이면 실패

user_home_missions

  • mission_id — bigint — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → Login.user_id — NOT NULL
  • status — VARCHAR(20)
  • Field (success_num) — bigint
  • Field (point) — bigint