Test

Tables (5)

Buy (Untitled5)

  • bno (Key) — number(20) — Primary key — NOT NULL
  • b_name (Field) — Varchar2(20)
  • b_phone (Field2) — number(20)
  • b_addr (Field4) — Varchar2(30)
  • b_request (Field3) — Varchar2(50)
  • id (Key2) — Varchar(20) — Foreign key → Member.id — NOT NULL
  • pno (Key3) — number(20) — Foreign key → Product.pno — NOT NULL

Cart (Untitled4)

  • pno (Key) — number(20) — Foreign key → Product.pno — NOT NULL
  • id (Key2) — Varchar(20) — Foreign key → Member.id — NOT NULL
  • Field

Groupbuy (Untitled3)

  • gno (Key) — number(10) — Primary key — NOT NULL
  • g_name (Field) — Varchar2(40)
  • g_price (Field2) — number(20)
  • g_discount (Field3) — number(2)
  • g_date (Field4) — date
  • g_like (Field5) — number(20)
  • g_count (Field6) — number(10)
  • g_del (Field7) — char(1)

Member (Untitled)

  • id (Key) — Varchar(20) — Primary key — NOT NULL
  • password (Field) — Varchar(20)
  • name (Field2) — Varchar(20)
  • address (Field3) — Varchar(40)
  • phone (Field4) — number(20)
  • gender (Field5) — Varchar(3)
  • age (Field6) — Number(3)
  • email (Field7) — Varchar(30)
  • reg_date (Field8) — Date
  • del (Field9) — Varchar(5)

Product (Untitled2)

  • pno (Key) — number(20) — Primary key — NOT NULL
  • p_name (Field) — Varchar2(40)
  • p_price (Field2) — number(20)
  • p_discount (Field3) — number(2)
  • p_date (Field4) — date
  • p_like (Field5) — number(20)
  • p_count (Field6) — number(10)
  • p_del (Field7) — char(1)