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