8th-mission1

Tables (8)

Food

  • Key (food_id) — int — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(10)
  • Field (content) — text

Member

  • Key (user_id) — bigint — Primary key — NOT NULL
  • 이름 (name) — Varchar(10) — NOT NULL
  • 성별 (gender) — Varchar(15)
  • 생년월일 (birth) — datetime(6)
  • 주소 (address) — text
  • Field (points) — int
  • Field (status) — varchar(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)

MemberFood

  • Key (mf_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Key (food_id) — int — Foreign key → Food.Key — NOT NULL

Untitled (Mission)

  • Key (mission_id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (dday) — datetime(6)
  • Field (price) — int
  • Field (points) — int
  • Field (content) — text

Untitled (Store)

  • Key (store_id) — bigint — Primary key — NOT NULL
  • Field (region) — varchar(20)
  • Field (name) — varchar(20)
  • Field (category) — varchar
  • Field (status) — varchar(10)

Untitled (MemberMission)

  • Key (mm_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (attempt_time) — datetime(6)
  • Field (status) — varchar(10)

Untitled (Review)

  • Key (review_id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (ratings) — float
  • Field (contents) — text

Untitled (Alarm)

  • Key (alarm_id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Member.Key — NOT NULL
  • Field (is_checked) — boolean
  • Field (content) — text
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (type) — varchar(10)