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