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)