umc

Tables (15)

Untitled (member)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(10) — NOT NULL
  • Field (gender) — varchar(6) — NOT NULL
  • Field (phone_number) — varchar(20) — NOT NULL
  • Field (birth_date) — date — NOT NULL
  • Field (status) — varchar(15) — NOT NULL
  • Field (inactive_at) — date — NOT NULL
  • Field (province) — varchar(50) — NOT NULL
  • Field (city) — varchar(50) — NOT NULL
  • Field (street) — varchar(50) — NOT NULL
  • Field (detail) — varchar(50) — NOT NULL
  • Field (zipcode) — varchar(10) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (food_category)

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

Untitled (favorite_food_category)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (food_category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (condition) — int — NOT NULL
  • Field (reward) — double — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (member_mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — varchar(20) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (store_owner)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (store_main_address) — varchar(100) — NOT NULL
  • Field (store_detail_address) — varchar(100) — NOT NULL
  • Field (owner_number) — varchar(30) — NOT NULL

Untitled (customer)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (point) — int — NOT NULL

Untitled (review_image)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — varchar(255) — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (is_read) — boolean — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL

Untitled (mission_alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (body) — varchar(100) — NOT NULL

Untitled (review_alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (body) — varchar(100) — NOT NULL

Untitled (marketing_alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (alarm_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (title) — varchar(100) — NOT NULL
  • Field (body) — varchar(100) — NOT NULL

Untitled (store)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_owner_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (category_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(30) — NOT NULL
  • Field (province) — varchar(100) — NOT NULL
  • Field (city) — varchar(50) — NOT NULL
  • Field (street) — varchar(50) — NOT NULL
  • Field (detail) — varchar(50) — NOT NULL
  • Field (zipcode) — varchar(10) — NOT NULL
  • Field (phone_number) — varchar(20) — NOT NULL
  • Field (open_at) — time — NOT NULL
  • Field (close_at) — time — NOT NULL
  • Field (rating) — double — NOT NULL

Untitled (comment)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (parent_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text — NOT NULL

Untitled (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (customer_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (rating) — double — NOT NULL
  • Field (created_at) — datetime(6) — NOT NULL
  • Field (updated_at) — datetime(6) — NOT NULL