new
Tables (4)
customers (고객)
- cust_code (고객코드) — number — Primary key — NOT NULL
- cust_name (고객이름) — varchar2
- quantity (펀드가입수) — number
- e_no (직원번호) — number — Foreign key → emps.e_no — NOT NULL
depts (부서)
- d_code (부서코드) — number — Primary key — NOT NULL
- d_name (부서명) — varchar2
- d_loc (부서위치) — varchar2
- d_phone (전화번호) — varchar2
emps (직원)
- e_no (직원번호) — number — Primary key — NOT NULL
- e_name (직원이름) — varchar2
- e_addr (직원주소) — varchar2
- hire_date (입사일) — date
- d_code (부서코드) — number — Foreign key → depts.d_code — NOT NULL
funds (펀드상품)
- fund_no (펀드번호) — number — Primary key — NOT NULL
- fund_name (펀드상품명) — varchar2
- fund_fee (납입금) — number
- pay_count (납입횟수) — number