20240409

Tables (3)

BizArea_MST (사업장)

  • bizarea_cd (Key) — integer — Primary key — NOT NULL
  • bizarea_tp (Field) — integer
  • bizarea_nm (Field2) — text
  • bizarea_reg (Field3) — text
  • business_tp (Field4) — text
  • bizarea_opdy (Field5) — text
  • kor_nm (Field6) — text
  • phone_num (Field7) — text
  • bizarea_contect_number (Field8) — text
  • bizarea_address1 (Field9) — text
  • bizarea_address2 (Field10) — text
  • bizarea_address3 (Field11) — text
  • sp_bizarea_cd (Field12) — integer

Emp_MST (사원)

  • emp_no (Key) — integer — Primary key — NOT NULL
  • kor_nm (Field) — text
  • emp_pstp (Field2) — integer
  • emp_rotp (Field3) — integer
  • bizarea_cd (Field4) — integer
  • phone_num (Field5) — text
  • social_num (Field6) — text
  • cd_trade (Field7) — text

Emp_pstp (직책 테이블)

  • pstp_cd (Key) — integer — Primary key — NOT NULL
  • pstp_nm (Field) — text