JAVA
Tables (6)
ADMIN_TB (Untitled4)
- admin_id (Key) — varchar2(10) — Primary key — NOT NULL
- admin_pwd (Field) — varchar2(20)
BOARD_TB (Untitled5)
- boardnum (Key) — varchar2(10) — Primary key — NOT NULL
- p_id (Key3) — varchar2(10) — Foreign key → PRODUCT_TB.p_id — NOT NULL
- title (Field3) — varchar2(10)
- content (Field4) — varchar2(10)
- hits (Field5) — number
- credate (Field6) — date
- member_id (Key2) — varchar2(10) — Foreign key → MEMBER_TB.member_id — NOT NULL
KEYWORD_TB (Untitled6)
- keyword_id (Key) — number — Primary key — NOT NULL
- member_id (Key3) — varchar2(10) — Foreign key → MEMBER_TB.member_id — NOT NULL
- keyword (Field) — varchar2(10)
- searchdate (Field3) — date
MEMBER_TB (Untitled)
- member_id (Key) — varchar2(10) — Primary key — NOT NULL
- password (Field) — varchar2(20)
- name (Field2) — varchar2(10)
- address (Field3) — varchar2(1000)
- indate (Field4) — date
- gender (Field5) — varchar2(1)
- age (Field11) — number(6)
ORDERS_TB (Untitled3)
- order_id (Key) — number — Primary key — NOT NULL
- p_id (Key4) — varchar2(1) — Foreign key → PRODUCT_TB.p_id — NOT NULL
- member_id (Key3) — varchar2(1) — Foreign key → MEMBER_TB.member_id — NOT NULL
- order_date (Field3) — date
- order_quan (Field4) — number
PRODUCT_TB (Untitled2)
- p_id (Key) — number — Primary key — NOT NULL
- p_name (Field) — varchar2(10)
- cost (Field2) — varchar2(10)
- price (Field3) — varchar2(10)
- stock (Field4) — varchar2(10)
- p_company (Field5) — varchar2(10)
- p_detail (Field6) — varchar2(10)