shppingmall
Tables (11)
cart (Untitled3)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (2) — bigint(20) — Foreign key → member.id — NOT NULL
- creat_time (Field) — date(6)
- updated_time (Field2) — date(6)
cart_item (Untitled7)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (Key2) — bigint(20) — Foreign key → cart.id — NOT NULL
- id (22) — bigint(20) — Foreign key → cart.id — NOT NULL
- id (Key3) — bigint(20) — Foreign key → item.id — NOT NULL
- created_time (Field) — datetime(6)
- updated_time (Field2) — datetime(6)
- cart_name (Field3) — varchar(100)
- cart_count (Field4) — int(11)
comment (Untitled4)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (Key2) — bigint(20) — Foreign key → item.id — NOT NULL
- commtent_contents (Field) — varchar(500)
- comment_write (Field2) — varchar(20)
- star_count (Field3) — int(11)
item (Untitled2)
- id (Key) — bigint(20) — Primary key — NOT NULL
- item_name (Field2) — varchar(100) — NOT NULL
- item_price (Field) — int(11) — NOT NULL
- item_sell_count (Field3) — int(11)
- item_count (Field5) — int(11)
- item_contents (Field4) — varchar(500)
- item_category (Field6) — varchar(30)
- create_time (Field7) — datetime(6)
- updated_time (Field8) — datetime(6)
- file_attached_item (Field9) — int(11)
item_file (Untitled8)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (Key2) — bigint(20) — Foreign key → item.id — NOT NULL
- original_file_name_item (Field) — varchar(100)
- stored_file_name_item (Field2) — varchar(100)
- created_time (Field3) — datetime(6)
- updated_time (Field4) — datetime(6)
member (Untitled)
- id — bigint(20) — Primary key — NOT NULL
- user_id (Field) — varchar(20) — NOT NULL
- member_name (Field2) — varchar(20) — NOT NULL
- member_password (Field3) — varchar(30) — NOT NULL
- member_mobile (Field4) — varchar(15) — NOT NULL
- member_address (Field5) — varchar(100)
- member_email (Field6) — varchar(30)
- created_time (Field7) — datetime(6)
- update_time (Field8) — datetime(6)
- detial_address (Field9) — varchar(100)
- extra_address (Field10) — varchar(100)
- postcode (Field11) — varchar(100)
order (Untitled5)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (2) — bigint(20) — Foreign key → member.id — NOT NULL
- order_name (Field) — varchar(100)
- order_status (Field2) — varchar(4)
- review (Field3) — varchar(10)
- created_time (Field4) — datetiem(6)
- update_tiem (Field5) — datetime(6)
order_ready (Untitled9)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (2) — bigint(20) — Foreign key → member.id — NOT NULL
- id (Key2) — bigint(20) — Foreign key → cart_item.id — NOT NULL
- id (Key22) — bigint(20) — Foreign key → cart_item.id — NOT NULL
- id (222) — bigint(20) — Foreign key → cart_item.id — NOT NULL
- id (Key3) — bigint(20) — Foreign key → cart_item.id — NOT NULL
- order_name (Field) — varchar(100)
- order_price (Field2) — int(11)
- item_image (Field3) — varchar(255)
- item_price_total (Field4) — int(11)
- cart_count (Field5) — int(11)
- created_time (Field6) — datetime(6)
- updated_time (Field7) — datetime(6)
orderitem (Untitled6)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (Key2) — bigint(20) — Foreign key → order.id — NOT NULL
- id (Key3) — bigint(20) — Foreign key → item.id — NOT NULL
- order_name (Field) — varchar(100)
- order_count (Field2) — int(11)
- created_time (Field3) — datetime(6)
- updated_time (Field4) — datetime(6)
- order_price (Field5) — int(11)
- Field6
question (Untitled10)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (2) — bigint(20) — Foreign key → member.id — NOT NULL
- question_name (Field) — varchar(20)
- question_status (Field2) — varchar(4)
- question_title (Field3) — varchar(50)
- question_contents (Field4) — varchar(500)
- created_time (Field5) — datetime(6)
- Field6
question_answer (Untitled11)
- id (Key) — bigint(20) — Primary key — NOT NULL
- id (Key2) — bigint(20) — Foreign key → question.id — NOT NULL
- id (22) — bigint(20) — Foreign key → question.id — NOT NULL
- reply_contents (Field) — varchar(500)
- reply_name (Field2) — varchar(20)
- created_time (Field3) — datetime(6)
- updated_time (Field4) — datetime(6)