WebMarketDB
Tables (4)
board
- num — int — Primary key — NOT NULL
- id — varchar(10) — Foreign key → member.id — NOT NULL
- name — varchar(10) — NOT NULL
- subject — varchar(100) — NOT NULL
- content — text — NOT NULL
- regist_day — varchar(30)
- hit — int
- ip — varchar(20)
member
- id — varchar(10) — Primary key — NOT NULL
- password — varchar(10) — NOT NULL
- name — varchar(10) — NOT NULL
- gender — varchar(4)
- birth — varchar(10)
- mail — varchar(30)
- phone — varchar(20)
- address — varchar(90)
- regist_day — varchar(50)
orders
- ordernum — int(10) — Primary key — NOT NULL
- id — varchar(10) — Foreign key → member.id — NOT NULL
- p_id — VARCHAR(10) — Foreign key → product.p_id — NOT NULL
- orderdate — varchar(50)
- address — varchar(90)
product
- p_id — VARCHAR(10) — Primary key — NOT NULL
- p_name — VARCHAR(20)
- p_unitPrice — INTEGER
- p_description — TEXT
- p_category — VARCHAR(20)
- p_manufacturer — VARCHAR(20)
- p_unitsInStock — LONG
- p_condition — VARCHAR(20)
- p_fileName — VARCHAR(20)