UMC_1주차

테이블 (6)

favor_food_category (Untitled2)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → food_category.Key — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field2 (updated_at) — DATETIME — NOT NULL
  • Key (food_category_id) — bigint — 외래 키 → user.Key — NOT NULL

food_category (Untitled6)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL

mission (Untitled4)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field2 (point) — int — NOT NULL
  • Field (status) — varchar(50) — NOT NULL
  • Field2 (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Key (restraurant_id) — bigint — 외래 키 → mission.Key — NOT NULL
  • Key (id2) — bigint — 외래 키 → restaurant.Key — NOT NULL

restaurant (Untitled3)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (region) — varchar(50) — NOT NULL
  • Field (address) — varchar(255) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL
  • Key (food_category_id) — bigint — 외래 키 → restaurant.Key — NOT NULL
  • Key (id2) — bigint — 외래 키 → food_category.Key — NOT NULL

user (Untitled)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (email) — VARCHAR(50) — NOT NULL
  • Field (password) — VARCHAR(50) — NOT NULL
  • Field (phone_number) — VARCHAR(50) — NOT NULL
  • Field (status) — VARCHAR(50) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Field (updated_at) — DATETIME — NOT NULL

user_mission (Untitled5)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
  • Field (completed_at) — varchar(50)
  • Field (created_at) — datetime — NOT NULL
  • Key (mission_id) — bigint — 외래 키 → mission.Key — NOT NULL