Test

Tables (7)

company (회사)

  • com_idx (index번호(PK)) — long — Primary key — NOT NULL
  • com_reg_nb (사업자등록번호) — Varchar
  • com_nm (회사명) — Varchar
  • com_tl_nb (회사대표전화) — Varchar
  • com_fax_nb (회사대표Fax번호) — Varchar
  • com_adr (회사주소) — Varchar
  • com_adr_zp (회사우편번호) — Varchar
  • com_ceo (CEO명) — Varchar
  • com_email (회사대표Email) — Varchar

product_part (부품)

  • part_idx (index번호(PK)) — long — Primary key — NOT NULL
  • sup_idx (supplier_index번호(FK)) — long — Foreign key → supplier.sup_idx — NOT NULL
  • part_nm (부품명) — Varchar
  • part_nb (부품번호) — Varchar
  • part_price (부품가격) — long
  • part_type (부품형태) — Varchar
  • part_cd (부품코드) — Varchar

project (프로젝트)

  • pj_idx (index번호(PK)) — long — Primary key — NOT NULL
  • com_idx (company_index번호(FK)) — long — Foreign key → company.com_idx — NOT NULL
  • staff_idx (프로젝트 담당 직원 index번호(PK)) — long — Foreign key → staff.staff_idx — NOT NULL
  • pj_nm (프로젝트명) — Varchar
  • pj_nb (프로젝트번호) — Varchar
  • pj_st_dt (프로젝트시작일) — Varchar
  • pj_ed_dt (프로젝트종료일) — Varchar
  • pj_adr (프로젝트주소(생산주소가 필요시)) — Varchar
  • pj_adr_zp (프로젝트우편번호(필요시)) — Varchar

project_part (프로젝트 부품)

  • pj_idx (index번호(PK)) — long — Foreign key → project.pj_idx — NOT NULL
  • part_idx (index번호(PK)2) — long — Foreign key → product_part.part_idx — NOT NULL
  • inven_qnt (재고수량) — long
  • nd_qnt (필요수량) — long
  • Field

project_staff (프로젝트_직원)

  • staff_idx (staff_index번호(FK)) — long — Foreign key → staff.staff_idx — NOT NULL
  • pj_idx (project_index번호(FK)) — long — Foreign key → project.pj_idx — NOT NULL
  • st_dt (투입시작일) — Varchar
  • ed_dt (투입종료일) — Varchar

staff (사원)

  • staff_idx (index번호(PK)) — long — Primary key — NOT NULL
  • com_idx (company_index번호(FK)) — long — Foreign key → company.com_idx — NOT NULL
  • staff_no (사원번호) — Varchar
  • staff_nm (사원명) — Varchar
  • birthday (사원생년월일) — Varchar
  • tl_no (사원전화번호) — Varchar
  • staff_ph_no (사원휴대폰번호) — Varchar
  • email (사원이메일) — Varchar
  • duty (직책) — Varchar
  • position (직위) — Varchar
  • departmant (부서) — Varchar

supplier (공급자)

  • sup_idx (index번호(PK)) — long — Primary key — NOT NULL
  • com_idx (company_index번호(FK)) — long — Foreign key → company.com_idx — NOT NULL