DB_week12
Tables (4)
Untitled (사원)
- Key (사원번호) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL
- Key3 — Primary key — NOT NULL
- Field
- Field2
Untitled (customer_level)
- Key (level_code) — char(1) — Primary key — NOT NULL
- Field (level_name) — varchar2(20)
- Field (discount_rate) — number(3,2)
Untitled (customer)
- Key (cid) — number(3) — Primary key — NOT NULL
- Field (cname) — varchar2(30)
- Field (mobile) — varchar2(15)
- Field (address) — varchar2(100)
- Field (accum_pur_amt) — number(10,1)
- Key (clevel) — char(1) — Foreign key → Untitled.Key — NOT NULL
Untitled
- Key — Primary key — NOT NULL
- Field
- Field2
- Field3