orderDB
Tables (5)
order_list (Untitled4)
- order_list_id (id) — bigint — Primary key — NOT NULL
- product_id — bigint — Foreign key → product.product_id — NOT NULL — reference(product.id)
- user_id — bigint — Foreign key → user_order.user_id — NOT NULL — reference(user_order.id)
- order_product_num (num) — int — NOT NULL
- order_time (created_time) — datetime
product (Untitled2)
- product_id (id) — bigint — Primary key — NOT NULL
- product_shop (shop_id) — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
- product_name (name) — varchar(255)
- product_stock (stock) — int — NOT NULL
- product_price (price) — int — NOT NULL
- product_contents (contents) — varchar(3000)
- created_time — datetime
user (Untitled)
- user_id (id) — bigint — Primary key — NOT NULL
- user_name (name) — varchar(255)
- user_email (email) — varchar(255)
- user_card (credit) — varchar(255)
- role — varchar(255) — NOT NULL — shop/ user(default)
- created_time — datetime
user_address (Untitled5)
- address_list (address_id) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
- address_country (country) — varchar(255)
- address_city (city) — varchar(255)
- address_street (street) — varchar(255)
user_order (Untitled3)
- order_id (id) — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → user.user_id — NOT NULL — reference(user.id)
- created_time — datetime