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