shopping

Tables (7)

cart (Untitled6)

  • cartnum (Key) — number(8) — Primary key — NOT NULL
  • id (Key3) — varchar2(20) — Foreign key → user.id — NOT NULL
  • prodnum (Key2) — number(5) — Foreign key → product.prodnum — NOT NULL
  • id (Field) — varchar2(20)
  • quantity (Field3) — number(5)
  • result (Field4) — char(1)
  • indate (Field5) — date
  • cart_seq (Field6) — sequence

employee (Untitled3)

  • id (Key) — varchar2(20) — Primary key — NOT NULL
  • pwd (Field) — varchar2(20)
  • name (Field2) — varchar2(20)
  • email (Field3) — varchar2(40)
  • phone (Field4) — varchar2(20)

order (Untitled2)

  • ordernum (Key) — number — Primary key — NOT NULL
  • id (Key2) — varchar2(20) — Foreign key → user.id — NOT NULL
  • indate (Field) — date
  • orders_seq (Field2) — sequence

order_detail (Untitled5)

  • odnum (Key) — number(10) — Primary key — NOT NULL
  • prodnum (Key3) — number(5) — Foreign key → product.prodnum — NOT NULL
  • ordernum (Key2) — number — Foreign key → order.ordernum — NOT NULL
  • quantity (Field3) — number(5)
  • result (Field4) — char(1)
  • order_detail_seq (Field5) — sequence

product (Untitled4)

  • prodnum (Key) — number(5) — Primary key — NOT NULL
  • name (Field) — varchar2(200)
  • kind (Field2) — char(1)
  • price1 (Field3) — number(7)
  • price2 (Field4) — number(7)
  • price3 (Field5) — number(7)
  • content (Field6) — varchar2(1000)
  • image (Field7) — varchar2(50)
  • useyn (Field8) — char
  • regdate (Field9) — date
  • product_seq (Field10) — sequence

qna (Untitled7)

  • qseq (Key) — number(5) — Primary key — NOT NULL
  • id (Key2) — varchar2(20) — Foreign key → user.id — NOT NULL
  • subject (Field) — varchar2(30)
  • content (Field2) — varchar2(1000)
  • reply (Field3) — varchar2(1000)
  • rep (Field5) — char(1)
  • indate (Field6) — date
  • qna_seq (Field7) — sequence

user (Untitled)

  • id (Key) — varchar2(20) — Primary key — NOT NULL
  • pwd (Field) — varchar2(20)
  • name (Field2) — varchar2(20)
  • email (Field3) — varchar2(40)
  • zip_code (Field4) — varchar2(7)
  • address (Field5) — varchar2(100)
  • phone (Field6) — varchar2(20)
  • useyn (Field7) — number
  • regdate (Field8) — date