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)