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)