UMC

Tables (5)

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

region

  • id — BIGINT
  • name — VARCHAR(15) — NOT NULL
  • 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