WebMarketDB

Tables (4)

board

  • num — int — Primary key — NOT NULL
  • id — varchar(10) — Foreign key → member.id — NOT NULL
  • name — varchar(10) — NOT NULL
  • subject — varchar(100) — NOT NULL
  • content — text — NOT NULL
  • regist_day — varchar(30)
  • hit — int
  • ip — varchar(20)

member

  • id — varchar(10) — Primary key — NOT NULL
  • password — varchar(10) — NOT NULL
  • name — varchar(10) — NOT NULL
  • gender — varchar(4)
  • birth — varchar(10)
  • mail — varchar(30)
  • phone — varchar(20)
  • address — varchar(90)
  • regist_day — varchar(50)

orders

  • ordernum — int(10) — Primary key — NOT NULL
  • id — varchar(10) — Foreign key → member.id — NOT NULL
  • p_id — VARCHAR(10) — Foreign key → product.p_id — NOT NULL
  • orderdate — varchar(50)
  • address — varchar(90)

product

  • p_id — VARCHAR(10) — Primary key — NOT NULL
  • p_name — VARCHAR(20)
  • p_unitPrice — INTEGER
  • p_description — TEXT
  • p_category — VARCHAR(20)
  • p_manufacturer — VARCHAR(20)
  • p_unitsInStock — LONG
  • p_condition — VARCHAR(20)
  • p_fileName — VARCHAR(20)