emAgency
Tables (7)
calInfo (달력 메모 정보)
- seq (순번) — Int — Primary key — NOT NULL
- r_date (등록일) — Alpha(10) — NOT NULL
- memo (메모) — Alpha(150) — NOT NULL
companyInfo (거래처 정보)
- Key (순번) — Int — Primary key — NOT NULL
- companyCode (거래처 코드) — Alpha(6) — Foreign key → companyInfo.Key — NOT NULL
- company (거래처 명) — Alpha(20)
- companyAddress (거래처 주소) — Alpha(100) — NOT NULL
- daeName (대표자) — Alpha(10) — NOT NULL
- tel (연락처) — Alpha(13) — NOT NULL
- memo (메모) — Alpha(150) — NOT NULL
- r_date (등록일) — Alpha(10)
- c_enabled (사용 여부) — Local
empolymentinfo (취업 정보)
- seq (순번) — Int — Primary key — NOT NULL
- r_date (등록일) — Alpha(10)
- companyCode (거래처 코드) — Alpha(6) — Foreign key → companyInfo.Key — NOT NULL
- company (회사명) — Alpha(20)
- siteCode (현장 코드) — Alpha(6) — Foreign key → siteInfo.seq — NOT NULL
- site (현장명) — Alpha(40)
- peopleCode (인력 코드) — Alpha(6) — Foreign key → peopleInfo.seq — NOT NULL
- people (인력명) — Alpha(20)
- jobCode (직종 코드) — Alpha(4) — Foreign key → occupationsInfo.seq — NOT NULL
- job (직종명) — Alpha(15)
- t_money (단가) — Int
- fee (수수료) — Int
- w_money (임금) — Int
- f_money (수수료 금액) — Int
- q_work (공수) — Int
- s_time (작업 시작 시간) — Time — NOT NULL
- e_time (작업 끝난 시간) — Time — NOT NULL
- memo (메모) — Alpha(150) — NOT NULL
myInfo (사업장 정보)
- cop (회사명) — Alpha(20) — NOT NULL
- repre (대표자) — Alpha(8)
- tel (연락처) — Alpha(12) — NOT NULL
- address (주소) — Alpha(100) — NOT NULL
- businessNum (사업자번호) — Alpha(12) — NOT NULL
- phone (핸드폰) — Alpha(13) — NOT NULL
occupationsInfo (직종 정보)
- seq (순번) — Int — Primary key — NOT NULL
- jobCode (직종 코드) — Alpha(4) — Foreign key → occupationsInfo.seq — NOT NULL
- jobName (직종 이름) — Alpha(15)
- wage (임금) — Alpha(12) — NOT NULL
- fee (수수료 (%)) — Alpha(3)
- orderSeq (정렬 순서) — Int
- enabled (사용 여부) — Local
peopleInfo (인력 정보)
- seq (순번) — Int — Primary key — NOT NULL
- dailyYN (일용/상용) — Alpha(1)
- jobCode (직종 코드) — Alpha(4) — Foreign key → occupationsInfo.seq — NOT NULL
- peopleCode (인력 코드) — Alpha(6) — Foreign key → peopleInfo.seq — NOT NULL
- name (이름) — Alpha(20)
- birth (생년월일) — Alpha(10)
- tel (연락처) — Alpha(13)
- address (주소) — Alpha(100) — NOT NULL
- memo (메모) — Alpha(150) — NOT NULL
- r_date (등록일) — Alpha(10)
siteInfo (현장 정보)
- seq (순번) — Int — Primary key — NOT NULL
- companyCode (거래처 코드) — Alpha(6) — Foreign key → companyInfo.Key — NOT NULL
- siteCode (현장 코드) — Alpha(6) — Foreign key → siteInfo.seq — NOT NULL
- site (현장) — Alpha(40)
- siteAddress (현장 주소) — Alpha(100)
- damName (담당자) — Alpha(10)
- damTel (연락처) — Alpha(13)
- s_money (금액) — Alpha(12) — NOT NULL
- memo (메모) — Alpha(150) — NOT NULL
- r_date (등록일) — Alpha(10)