temp_foot
Tables (16)
basket
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- productsize_id (product_id) — long — Foreign key → productsize.product_id — NOT NULL
bid
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- bidproductid — long — Foreign key → bidproduct.id — NOT NULL
- bidprice — long
bidproduct
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- brandid — long — Foreign key → brand.id — NOT NULL
- expiration_period — data
- start_price — long
- name — string
- description — string
bidproductfoot
- id — long — Primary key — NOT NULL
- bidproductid — long — Foreign key → bidproduct.id — NOT NULL
- id (id2) — long — Foreign key → bidproduct.brandid — NOT NULL
- footsize — long
- feetsize — long
- footpicture — string
- predictfootpicture — string
brand
- id — long — Primary key — NOT NULL
- name — string
channel
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- Key — Foreign key → user.Key — NOT NULL
- inviteduserid — long
chatlog (Untitled)
- id — long — Primary key — NOT NULL
- userid — long
- message — string
comment
- id — long — Primary key — NOT NULL
- productid — long — Foreign key → product.id — NOT NULL
- userid — long — Foreign key → user.Key — NOT NULL
- comments — string
favorite
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- productid — long — Foreign key → product.id — NOT NULL
orderhistory
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- productid — long — Foreign key → product.user_id — NOT NULL
product
- id — long — Primary key — NOT NULL
- brand_id — long — Foreign key → brand.id — NOT NULL
- user_id — long — Foreign key → user.id — NOT NULL
- name — string
- total_amount — long
- description — string
- price — long
- discountrate — string
- discountprice — long
productcolor
- id — long — Primary key — NOT NULL
- productsizeid — long — Foreign key → productsize.product_id — NOT NULL
- productcolorsid — long — Foreign key → productcolors.id — NOT NULL
- amount — long
productcolors
- id — long — Primary key — NOT NULL
- produtid (productid) — long — Foreign key → product.id — NOT NULL
- colorimg — string
- colorname — string
productsize
- id — long — Primary key — NOT NULL
- product_id — long — Foreign key → product.brand_id — NOT NULL
- size — long
- amount — long
- footsize — long
- feetsize — long
- footpicture — string
- predictfootpicture — string
user
- id — long — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- email — string
- name — string
- password — string
- address — string
- cellphone — string
- role — enum
- userimage — string
userfoot
- id — long — Primary key — NOT NULL
- userid — long — Foreign key → user.id — NOT NULL
- Key — Foreign key → user.Key — NOT NULL
- footsize — long
- feetsize — long
- footpicture — string
- predictfootpicture — string