Nitome
Tables (7)
admin_tb (Untitled5)
- admin_id (Key) — varchar2(10) — Primary key — NOT NULL
- admin_pwd (Field) — number
board_tb (Untitled6)
- boardnum (Key) — number — Primary key — NOT NULL
- member_id (Key2) — varchar2(500) — Foreign key → member_tb.member_id — NOT NULL
- p_id (Key3) — number — Foreign key → product_tb.p_id — NOT NULL
- name (Field) — varchar2(10)
- title (Field2) — varchar2(100)
- content (Field3) — varchar2(2000)
- hits (Field4) — number
- credate (Field5) — date
cart_tb (Untitled4)
- cart_id (Key) — number — Primary key — NOT NULL
- member_id (Key4) — varchar2(500) — Foreign key → member_tb.member_id — NOT NULL
- p_id (Key2) — number — Foreign key → product_tb.p_id — NOT NULL
- cart_quan (Field) — number
keyword_tb (Untitled7)
- keyword_id (Key) — number — Primary key — NOT NULL
- member_id (Key2) — varchar2(10) — Foreign key → member_tb.member_id — NOT NULL
- keyword (Field) — varchar2(20)
- searchdate (Field2) — date
member_tb (Untitled)
- member_id (Key) — varchar2(500) — Primary key — NOT NULL
- password (Field) — varchar2(10)
- name (Field2) — varchar2(500)
- address (Field3) — varchar2(1024)
- indate (Field4) — date
- gender (Field5) — varchar2(1)
- age (Field6) — number(6)
orders_tb (Untitled3)
- order_id (Key) — number — Primary key — NOT NULL
- member_id (Key2) — varchar2(500) — Foreign key → member_tb.member_id — NOT NULL
- p_id (Key3) — number — Foreign key → product_tb.p_id — NOT NULL
- order_date (Field2) — date
- order_quan (Field3) — number
product_tb (Untitled2)
- p_id (Key) — number — Primary key — NOT NULL
- p_name (Field) — varchar2(200)
- cost (Field2) — number
- price (Field3) — number
- stock (Field4) — number
- p_company (Field5) — varchar2(100)
- p_detail (Field6) — varchar2(4000)