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