UMC CH1

Tables (8)

Untitled (user_mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (status) — varchar(10) — NOT NULL
  • id (missioin_id) — bigint — Foreign key → mission.id — NOT NULL — unique
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL — unique

food_type

  • id — bigint — Primary key — NOT NULL
  • name — varchar(15) — NOT NULL

mission

  • id — bigint — Primary key — NOT NULL
  • description — varchar(120) — NOT NULL
  • id (store_id) — bigint — Foreign key → store.id — NOT NULL
  • id (region_id) — bigint — Foreign key → region.id — NOT NULL

region

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10) — NOT NULL

region_mission (user_region_mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • success_count — bigint — NOT NULL
  • status — varchar(10) — NOT NULL
  • id (region_id) — bigint — Foreign key → region.id — NOT NULL — unique
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL — unique

store

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • id (food_type_id) — bigint — Foreign key → food_type.id — NOT NULL
  • id (region_id) — bigint — Foreign key → region.id — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • social_type — varchar(10) — NOT NULL
  • name — varchar(10) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • birth — datetime — NOT NULL
  • address — varchar(60) — NOT NULL
  • credated_at (created_at) — datetime(6) — NOT NULL
  • updated_at — datetime(6)

user_preference

  • id — bigint — Primary key — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL
  • id (food_type_id) — bigint — Foreign key → food_type.id — NOT NULL
  • id (user_id) — bigint — Foreign key → user.id — NOT NULL