UMC

Tables (10)

food_category

  • id — BIGINT
  • name — VARCHAR(15) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

member

  • id — BIGINT
  • name — VARCHAR(20) — NOT NULL
  • birth — DATE
  • address — VARCHAR(50)
  • spec_address — VARCHAR(50)
  • point — INT
  • status — VARCHAR(15)
  • inactive_date — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

member_agree

  • member_id — BIGINT — Primary key — NOT NULL
  • terms_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

member_mission

  • member_id — BIGINT — Primary key — NOT NULL
  • mission_id — BIGINT — Primary key — NOT NULL
  • status — VARCHAR(15)
  • created_at — DATETIME
  • updated_at — DATETIME

member_prefer

  • member_id — BIGINT — Primary key — NOT NULL
  • food_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

mission

  • id — BIGINT
  • store_id — BIGINT — NOT NULL
  • reward — INT — NOT NULL
  • spec — VARCHAR(100) — NOT NULL
  • dead_line — DATE
  • created_at — DATETIME
  • updated_at — DATETIME

region

  • id — BIGINT
  • name — VARCHAR(15) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

review

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • title — VARCHAR(10)
  • content — TEXT
  • score — DECIMAL(2,1)
  • created_at — DATETIME
  • updated_at — DATETIME

store

  • id — BIGINT
  • region_id — BIGINT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • lat — DECIMAL(10,8)
  • lng — DECIMAL(11,8)
  • address — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

terms

  • id — BIGINT
  • title — VARCHAR(20) — NOT NULL
  • content — TEXT — NOT NULL
  • optional — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME