shop-be
Tables (5)
delivery (Delivery)
- delivery_id — bigint — Primary key — NOT NULL
- city — varchar(255)
- street — varchar(255)
- zipcode — varchar(255)
- status — enum('READY','COMP')
item (Item)
- item_id — bigint — Primary key — NOT NULL
- dtype — varchar(31) — NOT NULL
- name — varchar(255)
- price — int — NOT NULL
- stock_quantity — int — NOT NULL
- author — varchar(255)
- isbn — varchar(255)
- artist — varchar(255)
- etc — varchar(255)
- actor — varchar(255)
- director — varchar(255)
member (Member)
- member_id — bigint — Primary key — NOT NULL
- city — varchar(255)
- street — varchar(255)
- zipcode — varchar(255)
- name — varchar(255)
order_item (OrderItem)
- order_item_id — bigint — Primary key — NOT NULL
- count — int — NOT NULL
- order_price — int — NOT NULL
- item_id — bigint — Foreign key → item.item_id
- order_id — bigint — Foreign key → orders.order_id
orders (Order)
- order_id — bigint — Primary key — NOT NULL
- order_date — datetime(6)
- status — enum('ORDER','CANCEL')
- delivery_id — bigint — Foreign key → delivery.delivery_id
- member_id — bigint — Foreign key → member.member_id