BIDPROJECT
Tables (4)
Untitled (USER1)
- Key (ID) — varchar2(20) — Primary key — NOT NULL
- Key2 (USERNAME) — varchar2(20) — Primary key — NOT NULL
- Field (PASSWORD) — varchar2(20)
- Field2 (ROADFULLADDR) — varchar2(200)
- Field3 (PHONE) — varchar2(20)
- Field (PWQUESTION) — varchar2(100)
- Field (PWANSWER) — varchar2(20)
Untitled (SALES)
- Key (CODE) — varchare2(20) — Primary key — NOT NULL
- Key2 (TERM) — varchar2(20) — Primary key — NOT NULL
- Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
- Key2 (USERNAME) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
- Field (CAT1) — varchar2(20)
- Field (PRODNAME) — varchar2(200)
- Field (PRICE) — number
- Field (CONDITION) — varchar2(50)
- Field (REF) — varchar2(1000)
- Field (DESCRIP) — varchar2(4000)
Untitled (BOARD)
- Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
- Key2 (USERNAME) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
- Field (SEQ) — number
- Field2 (SUBJECT) — varchar2(255)
- Field3 (CONTENT) — varchar2(4000)
- Field4 (LEV) — number
- Field (STEP) — number
- Field (PSEQ) — number
- Field (REPLY) — number
- Field (HIT) — number
- Field (LOGTIME) — DATE
Untitled (AUCTION)
- Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
- Key (CODE) — varchare2(20) — Foreign key → Untitled.Key — NOT NULL
- Key2 (TERM) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
- Field (FINALPRICE) — number