cuk_edu

Tables (5)

customers

  • c_id — int — Primary key — NOT NULL — 고객번호
  • c_name — varchar(15) — NOT NULL — 고객이름
  • c_number — char(10) — NOT NULL — 고객전화번호
  • c_adress — varchar(50) — NOT NULL — 고객주소
  • c_birth — date — 고객생일
  • c_job — varchar — 고객직업

department

  • d_id — int — Primary key — NOT NULL — 부서번호
  • d_name — varchar(50) — NOT NULL — 부서명

employees

  • e_id — int — Primary key — NOT NULL — 직원번호
  • d_id — int — Foreign key → department.d_id — NOT NULL — 부서번호
  • e_name — varchar(50) — NOT NULL — 직원이름
  • e_sex — char(1) — NOT NULL — 직원성별
  • e_join — date — NOT NULL — 입사일

products

  • p_id — int — Primary key — NOT NULL — 상품번호
  • d_id (d_id2) — int — Foreign key → department.d_id — NOT NULL — 부서번호
  • p_name — varchar(50) — NOT NULL — 상품이름
  • p_manfc — varchar(50) — 제조사
  • p_mandate — date — NOT NULL — 제조일
  • p_expired — date — NOT NULL — 유통기한
  • p_price — decimal(6, 2) — NOT NULL — 가격

purchase

  • pur_id — int — Primary key — NOT NULL — 구매번호
  • c_id (c_id2) — int — Foreign key → customers.c_id — NOT NULL — 고객번호
  • p_id (p_id2) — int — Foreign key → products.p_id — NOT NULL — 상품번호
  • pur_date — datetime — NOT NULL — 구매일
  • pur_amount — int — NOT NULL — 구매수량
  • p_id — int — 상품번호