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