shopping
Tables (5)
category
- cateno — INT — Primary key — NOT NULL
- catename — VARCHAR(50) — NOT NULL
- categrpno — INT
contents
- contentsno — INT — Primary key — NOT NULL
- cateno — INT — Foreign key → category.cateno — NOT NULL
- pname — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
- filename — VARCHAR(100)
- detail — LONGTEXT — NOT NULL
- rdate — DATE — NOT NULL
- stock — INT — NOT NULL
member
- id — VARCHAR(10) — Primary key — NOT NULL
- passwd — VARCHAR(20) — NOT NULL
- mname — VARCHAR(20) — NOT NULL
- tel — VARCHAR(14)
- email — VARCHAR(50) — NOT NULL
- zipcode — VARCHAR(7)
- address1 — VARCHAR(150)
- address2 — VARCHAR(50)
- job — VARCHAR(20) — NOT NULL
- mdate — DATE — NOT NULL
- fname — VARCHAR(50) — NOT NULL
- grade — VARCHAR(1) — NOT NULL
order_detail
- odno — int — Primary key — NOT NULL
- contentsno — INT — Foreign key → contents.contentsno — NOT NULL
- orderno — int — Foreign key → orders.orderno — NOT NULL
- cateno — INT — Foreign key → contents.cateno — NOT NULL
- id — VARCHAR(10) — Foreign key → orders.id — NOT NULL
- quantity — int — NOT NULL
- pname — VARCHAR(50) — NOT NULL
- size — Varchar(3) — NOT NULL
orders
- orderno — int — Primary key — NOT NULL
- id — VARCHAR(10) — Foreign key → member.id — NOT NULL
- mname — VARCHAR(20) — NOT NULL
- odate — DATE — NOT NULL
- ostate — VARCHAR(50) — NOT NULL
- total — int — NOT NULL
- payment — VARCHAR(50) — NOT NULL
- reqtext — varchar(50) — NOT NULL