baemin

Tables (17)

Untitled (store_menu)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_menu_category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (description) — TEXT
  • Field (price) — INT
  • Field (image) — VARCHAR(500)
  • Field (priority) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (coupon_info)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (code) — VARCHAR(20)
  • Field (type) — TINYINT
  • Field (amount) — INT
  • Field (min_order_amount) — INT
  • Field (status) — TINYINT
  • Field (duration) — INT
  • Field (created_at) — DATETIME

Untitled (coupon)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (coupon_info_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME
  • Field (expired_at) — DATETIME

Untitled (order_payment)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (order_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — TINYINT
  • Field (pg_payment_id) — VARCHAR(100)
  • Field (amount) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (order_menu_option)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (order_menu_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_menu_option_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (price) — INT
  • Field (priority) — INT
  • Field (created_at) — DATETIME

Untitled (order_menu)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (order_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_menu_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (description) — TEXT
  • Field (price) — INT
  • Field (image) — VARCHAR(500)
  • Field (priority) — INT
  • Field (created_at) — DATETIME

Untitled (order)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (area_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (coupon_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (address) — VARCHAR(200)
  • Field (memo) — TEXT
  • Field (delivery_fee) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (store_menu_option)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_menu_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (price) — INT
  • Field (priority) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (store_menu_category)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (description) — TEXT
  • Field (priority) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (store)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (category_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (description) — TEXT
  • Field (owner) — VARCHAR(20)
  • Field (phone) — VARCHAR(20)
  • Field (address) — VARCHAR(200)
  • Field (open_time) — TIME
  • Field (close_time) — TIME
  • Field (min_order_amount) — INT
  • Field (delivery_fee) — INT
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (store_review_reply)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (review_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (comment) — TEXT
  • Field (created_at) — DATETIME

Untitled (store_category)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (created_at) — DATETIME

Untitled (user)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(500)
  • Field (password) — VARCHAR(100)
  • Field (nickname) — VARCHAR(20)
  • Field (phone) — VARCHAR(20)
  • Field (status) — TINYINT
  • Field (created_at) — DATETIME

Untitled (store_review)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (order_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (rating) — INT
  • Field (comment) — TEXT
  • Field (image) — VARCHAR(500)
  • Field (created_at) — DATETIME

Untitled (store_area)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (area_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — DATETIME

Untitled (area)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (parent_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(20)
  • Field (latitude) — DOUBLE
  • Field (longitude) — DOUBLE
  • Field (distance) — DOUBLE
  • Field (created_at) — DATETIME

Untitled (store_image)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (type) — TINYINT
  • Field (url) — VARCHAR(500)
  • Field (created_at) — DATETIME