umc-ch04-mission

Tables (14)

Untitled (region)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field (update_at) — datetime(6)
  • Field2 (delete_at) — Boolean

Untitled (member_agree)

  • Key (id) — bigint — Primary key — NOT NULL
  • id (member_id) — bigint — Foreign key → member.id — NOT NULL
  • Key (terms_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — datetime(6)
  • Field (update_at) — datetime(6)
  • Field (delete_at) — boolean

Untitled (terms)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar(20)
  • Field (body) — text
  • Field (optional) — boolean
  • Field (created_at) — datetime(6)
  • Field (update_at) — datetime(6)
  • Field (delete_at) — boolean

food (food_category)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

food_choice (member_prefer)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • food_id — bigint — Foreign key → food.id — NOT NULL
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

inquiry

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(200)
  • category — varchar(30)
  • content — text
  • status — varchar(10)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

inquiry_img

  • id — bigint — Primary key — NOT NULL
  • inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL
  • img_url — varchar(500)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(10)
  • birth_date — date
  • phone_num — varchar(15)
  • address — varchar(255)
  • email — varchar(255)
  • gender — varchar(10)
  • status — varchar(15)
  • inactive_date — datetime
  • created_at — datetime(6)
  • update_at — datetime(6)
  • nickname — varchar(50)
  • profile_img — varchar(255)

mission

  • id — bigint — Primary key — NOT NULL
  • id (store_id) — bigint — Foreign key → shop.id — NOT NULL
  • info — text
  • expiration_date (Field) — datetime
  • point (Field2) — int
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

mission_management (member_mission)

  • id — bigint — Primary key — NOT NULL
  • mission_id (missiom_id) — bigint — Foreign key → mission.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • status — varchar(10)
  • Authen_num — int
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

review

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • shop_id — bigint — Foreign key → shop.id — NOT NULL
  • content — text
  • horoscope — int
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

review_img

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → review.id — NOT NULL
  • img_url — varchar(500)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

shop (store)

  • id — bigint — Primary key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • name — varchar(100)
  • address — varchar(255)
  • food_category — varchar(20)
  • all_rate — double
  • sales_status — varchar(5)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean

shop_img (store_img)

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — Foreign key → shop.id — NOT NULL
  • img_url — varchar(500)
  • created_at — datetime(6)
  • update_at — datetime(6)
  • delete_at — boolean