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)