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)