ecommerce-msa
Tables (9)
deliveries
- delivery_id — bigint — NOT NULL
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- completed_date_time — datetime(6)
- message — varchar(50)
- receiver_address — varchar(255) — NOT NULL
- receiver_name — varchar(50) — NOT NULL
- tell_number — varchar(50) — NOT NULL
members
- user_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- address — varchar(255) — NOT NULL
- email — varchar(50) — NOT NULL
- name — varchar(50) — NOT NULL
- password — varchar(60) — NOT NULL
- role — enum — NOT NULL
- tell_number — varchar(50) — NOT NULL
order_items
- order_item_id — bigint
- quantity — int
- option_id — bigint — NOT NULL
- order_id — bigint — NOT NULL
orders
- order_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- amount_payment — int — NOT NULL
- confirmed_date_time — datetime(6)
- status — enum — NOT NULL
- member_id — bigint — NOT NULL
product_options
- product_option_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- count — int — NOT NULL
- name — varchar(30) — NOT NULL
- type — enum — NOT NULL
- price — int — NOT NULL
- product_id — bigint — NOT NULL
products
- product_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- category — enum — NOT NULL
- info — varchar(255)
- name — varchar(255) — NOT NULL
- stock_quantity — int — NOT NULL
- thumbnail_img_url — varchar(255)
- store_id — bigint — NOT NULL
- price — int — NOT NULL
stores
- store_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- info — varchar(255) — NOT NULL
- name — varchar(30) — NOT NULL
- tell_number — varchar(50) — NOT NULL
wishlist
- wish_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- member_id — bigint — NOT NULL
- product_id — bigint — NOT NULL
wishlist_items
- wish_item_id — bigint
- created_date_time — datetime(6) — NOT NULL
- modified_date_time — datetime(6)
- quantity — int
- option_id — bigint — NOT NULL
- wishlist_id — bigint — NOT NULL