dbtest
Tables (6)
Untitled (사원)
- Key (사원번호) — Primary key — NOT NULL
- Key (부서번호2) — Foreign key → Untitled.Key — NOT NULL
- Field (사원명)
- Field2 (담당업무)
- Field3 (매니저)
- Field4 (입사일자)
- Field (급여)
- Field2 (보너스)
- Field3 (부서번호)
Untitled (부서)
- Key (부서번호) — Primary key — NOT NULL
- Field (부서명)
- Field2 (부서위치)
Untitled (회원등급)
- Key (등급코드) — Primary key — NOT NULL
- Field (등급명)
- Field2 (할인율)
Untitled (고객)
- Key (회원번호) — Primary key — NOT NULL
- Key (등급코드) — Foreign key → Untitled.Key — NOT NULL
- Field (이름)
- Field2 (연락처)
- Field3 (주소)
- Field4 (누적구매금액)
- Field5 (회원등급)
Untitled (customer_level)
- Key (level) — char(1) — Primary key — NOT NULL
- Field (level_name) — varchar2(20)
- Field2 (discount_rate) — number(3,2)
Untitled (customer)
- Key (cid) — number(3) — Primary key — NOT NULL
- Field (cname) — varchar2(30)
- Field2 (mobile) — varchar2(15)
- Field3 (address) — varchar2(100)
- Field4 (accum_pur_amt) — number(10,1)
- Field5 (clevel(FK)) — char(1)
- Key (lcode) — char(1) — Foreign key → Untitled.Key — NOT NULL