CAR SHOP
테이블 (5)
b_qna
- b_no — number — NOT NULL
- b_title — varchar2(50)
- b_pwd — number
- b_writer — varchar2(15)
- b_content — varchar2(2000)
- b_date — date
- b_readcount — number
- b_category — varchar2(50)
- pID — varchar2(30)
- lock_flag — char(1)
buy
- orderno — number — NOT NULL
- res_name — varchar2(20)
- res_address — varchar2(100)
- res_phone — char(11)
- memberid — varchar2(15) — NOT NULL
- res_requirement — varchar2(100)
- totalprice — number
- orderdate — date
member
- memberid — varchar2(15) — NOT NULL
- membername — varchar2(20)
- gender — char(1)
- age — number
- email — varchar2(30)
- phone — char(11)
- favorite — varchar2(50)
- grade — varchar2(15)
- enrolldate — date
- delflag — char(1)
- deletedate — date
- regflag — char(1)
- password — varchar2(300)
product_io
- iono — number — NOT NULL
- pID — varchar2(30) — NOT NULL
- orderno — number — NOT NULL
- amount — number
- status — varchar2(10)
- pDate — date
- memberid — varchar2(15) — NOT NULL
자동차 (product)
- 자동차id (carid) — varchar2(30) — 기본 키 — NOT NULL
- 자동차명 (carname) — varchar2(30)
- 자동차종류 (carcategory) — varchar2(30)
- 자동차가격 (carprice) — number(10)
- 자동차색상 (carcolor) — varchar2(50)
- 자동차제조사 (carcompany) — varchar2(30)
- 자동차재고 (carstock) — number