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