spring
Tables (7)
cart
- cartid — INT(11) — Primary key — NOT NULL
- userid — VARCHAR(50) — NOT NULL
- productcount — INT(11)
- checked — INT(11)
- registerdate — TIMESTAMP
- productid — INT(11)
- USERID — VARCHAR(20) — Foreign key → member.USERID — NOT NULL
deletemember
- USERID — VARCHAR(50) — Primary key — NOT NULL
- PWD — VARCHAR(50)
- NAME — VARCHAR(50)
- SEX — VARCHAR(50)
- ADDRESS — VARCHAR(50)
- PHONE — VARCHAR(50)
- EMAIL — VARCHAR(50)
- CREATEDATE — TIMESTAMP
- GRADE — VARCHAR(50)
- ISDORMANT — VARCHAR(50)
- DELETEDATE — TIMESTAMP
member
- USERID — VARCHAR(20) — Primary key — NOT NULL
- PWD — VARCHAR(20)
- NAME — VARCHAR(20)
- SEX — VARCHAR(20)
- ADDRESS — VARCHAR(20)
- PHONE — VARCHAR(20)
- EMAIL — VARCHAR(20)
- CREATEDATE — TIMESTAMP
- GRADE — VARCHAR(50)
- ISDORMANT — VARCHAR(10)
order
- orderid — INT(11) — Primary key — NOT NULL
- address — VARCHAR(50)
- memberid — VARCHAR(50)
- sender — VARCHAR(50)
- receiver — VARCHAR(50)
- orderdate — TIMESTAMP
- receiverphone — VARCHAR(50)
- totalprice — INT(11)
- orderstate — VARCHAR(50)
- receiver_location — VARCHAR(50)
- INDEX — `FK_order_member`
- USERID — VARCHAR(20) — Foreign key → member.USERID — NOT NULL
orderitem
- orderitemid — INT(11) — Primary key — NOT NULL
- orderid — INT(11) — Foreign key → order.orderid
- productcount — INT(11)
- userid — VARCHAR(50)
- isPurchased — INT(11)
- productid — INT(11)
product
- productid — INT(11) — Primary key — NOT NULL
- isbn — VARCHAR(50)
- productname — VARCHAR(50)
- price — INT(11)
- discount — INT(11)
- description — TEXT
- booktype — VARCHAR(50)
- salestype — VARCHAR(50)
- publisher — VARCHAR(50)
- writer — VARCHAR(50)
- totalpage — INT(11)
- bookindex — TEXT
- publishdate — TIMESTAMP
- thumbnail — VARCHAR(100)
- registerdate — TIMESTAMP
- cartid — INT(11) — Foreign key → cart.cartid — NOT NULL
productimage
- imagenum — INT(11) — Primary key — NOT NULL
- productid — INT(11)
- org_name — VARCHAR(50)
- contenttype — VARCHAR(50)
- real_name — VARCHAR(50)
- INDEX — `FK_productimage_product`