projecthb

Tables (21)

PROJHUB_DOMAIN_EQUIPMENT

  • EQUIP_NAME — varchar(60) — Primary key — NOT NULL
  • STANDARD_NAME — varchar(60) — Primary key — NOT NULL
  • PROJ_ID (PROJ_ID2) — varchar(20) — Foreign key → PROJHUB_MGMT_PROJ.PROJ_ID — NOT NULL — 공사코드
  • USAGE_CNT — int(11)

PROJHUB_DOMAIN_MATERIAL

  • MEASURE_NAME — varchar(30) — Primary key — NOT NULL
  • MEASURE_NAME (MEASURE_NAME2) — varchar(20) — Foreign key → PROJHUB_DOMAIN_MEASURE.MEASURE_NAME — NOT NULL
  • PROJ_ID (PROJ_ID2) — varchar(20) — Foreign key → PROJHUB_MGMT_PROJ.PROJ_ID — NOT NULL — 공사코드
  • STANDARD_NAME (STANDARD_NAME2) — varchar(60) — Foreign key → PROJHUB_DOMAIN_STANDARD.STANDARD_NAME — NOT NULL
  • USAGE_CNT — int(11)

PROJHUB_DOMAIN_MEASURE

  • ID — int(11) — Primary key — NOT NULL
  • MEASURE_NAME — varchar(20) — Primary key — NOT NULL

PROJHUB_DOMAIN_ROLE

  • ROLE_NAME — varchar(60) — Primary key — NOT NULL
  • PROJ_ID (PROJ_ID2) — varchar(20) — Foreign key → PROJHUB_MGMT_PROJ.PROJ_ID — NOT NULL — 공사코드
  • USAGE_CNT — int(11)

PROJHUB_DOMAIN_SITE

  • PROJ_ID — varchar(20) — Primary key — NOT NULL
  • COMPLEX — varchar(60) — Primary key — NOT NULL
  • BUILDING — varchar(30) — Primary key — NOT NULL
  • FLOOR — varchar(30) — Primary key — NOT NULL

PROJHUB_DOMAIN_STANDARD

  • PROJ_ID — varchar(20) — Primary key — NOT NULL
  • STANDARD_NAME — varchar(60) — Primary key — NOT NULL
  • TYPE — varchar(15) — Primary key — NOT NULL — 자재(materia)/장비(equip)

PROJHUB_MGMT_EQUIPMENT

  • ID — int(11) — Primary key — NOT NULL
  • EQUIP_ID — varchar(25) — Primary key — NOT NULL
  • PROJ_ID — varchar(20)
  • REPORT_DATE — datetime
  • COMPANY_NAME — varchar(60)
  • CONSTRUCT_NAME — varchar(60)
  • EQUIP_UNIT — varchar(60)
  • EQUIP_QTY — int(11)
  • APPROVED — varchar(6)
  • READED — varchar(6)
  • READ_LIST — varchar(500) — worker id list. Array type. e.g. ’2’ of worker-2.
  • CREATED_DT — timestamp

PROJHUB_MGMT_ITEM_SUM

  • PROJ_ID — varchar(20) — Primary key — NOT NULL
  • COMPANY_NAME — varchar(60) — Primary key — NOT NULL
  • CONSTRUCT_NAME — varchar(60) — Primary key — NOT NULL
  • ITEM_NAME — varchar(60) — Primary key — NOT NULL
  • TYPE — varchar(6) — 출력 E : 장비 M : 자재
  • ITEM_SUM — int(11)

PROJHUB_MGMT_MATERIAL

  • ID — int(11) — Primary key — NOT NULL
  • MATERIAL_ID — varchar(25) — Primary key — NOT NULL
  • PROJ_ID — varchar(20)
  • REPORT_DATE — datetime
  • COMPANY_NAME — varchar(60)
  • CONSTRUCT_NAME — varchar(60)
  • MATERIAL_UNIT — varchar(60)
  • MATERIAL_QTY — int(11)
  • APPROVED — varchar(6) — Y/N
  • READED — varchar(6)
  • READ_LIST — varchar(500) — worker id list. Array type. e.g. ’2’ of worker-2.
  • CREATED_DT — timestamp — NOT NULL

PROJHUB_MGMT_OUTPUT

  • ID — int(11) — Primary key — NOT NULL
  • OUTPUT_ID — varchar(25) — Primary key — NOT NULL
  • PROJ_ID — varchar(20)
  • REPORT_DATE — datetime
  • COMPANY_NAME — varchar(60)
  • CONSTRUCT_NAME — varchar(60)
  • OUTPUT_CONTENT — text — Ex) {‘보인': 4, '미장':
  • ...}, — `APPROVED` — Y/N
  • READED — varchar(6)
  • READ_LIST — varchar(500) — worker id list. Array type. e.g. ’2’ of worker-2.
  • CREATED_DT — timestamp

PROJHUB_MGMT_PRESET

  • ID — int(11) — Primary key — NOT NULL
  • PRESET_ID — varchar(20) — Primary key — NOT NULL
  • KAKAO_AUTH — varchar(15) — NOT NULL
  • PROJ_ID — varchar(10)
  • PRESET_OUTPUT — text
  • PRESET_MATERIAL — text
  • PRESET_EQUIP — text

PROJHUB_MGMT_PROJ

  • PROJ_ID — varchar(20) — Primary key — NOT NULL — 공사코드
  • PROJ_NAME — varchar(90) — 공사명
  • PROJ_COMPANY_NAME — varchar(60) — 업체
  • PROJ_ASSIGN_TO — varchar(60) — 책임자
  • PROJ_APPROVED_DT — datetime — 허가일
  • PROJ_START_DT — datetime — 착공일
  • CREATED_DT — timestamp

PROJHUB_MGMT_PUSH_LOG

  • ID — int(11) — Primary key — NOT NULL
  • PUSH_ID — varchar(25) — Primary key — NOT NULL
  • WORKER_ID — varchar(20)
  • PROJ_ID — varchar(20)
  • COMPANY_NAME — varchar(60)
  • TYPE — varchar(10) — O/M/E/T/TL/TP
  • TYPEKOR — varchar(30) — 출력/자재/장비/작업
  • CRUD — varchar(3)
  • REPORT_ID — varchar(1000) — Ex) todo-mgmt-2\nequip-mgmt-3\nequip-mgmt-3
  • CONTEXT — varchar(300) — ex) '아이디어샘'에서 자재보고 하였습니다
  • READ_LIST — varchar(500)
  • CREATED_DT — timestamp

PROJHUB_MGMT_TODO

  • ID — int(11) — Primary key — NOT NULL
  • TODO_ID — varchar(25) — Primary key — NOT NULL
  • PROJ_ID — varchar(20)
  • COMPANY_NAME — varchar(60)
  • FINISHED — varchar(6)
  • APPROVED — varchar(6)
  • FINISHED_DATE — date
  • TODO_DETAIL — varchar(25) — Ex) todo-detail-1
  • READ_LIST — varchar(500) — worker id list. Array type. e.g. ’2’ of worker-2.
  • CREATED_DT — timestamp

PROJHUB_MGMT_TODO_DETAIL

  • ID — int(11) — Primary key — NOT NULL
  • TODO_DETAIL_ID — varchar(25) — Primary key — NOT NULL
  • COMPANY_IN_CHARGE — varchar(100)
  • TODO_CATEGORY — varchar(60)
  • TODO_TITLE — varchar(90)
  • TODO_SITE_BASIC — varchar(130)
  • TODO_SITE_DETAIL — varchar(150)
  • TODO_CONTENT — varchar(600)
  • PERIOD_START — date
  • PERIOD_END — date
  • TODO_PICTURES — text
  • TODO_LOGS — text

PROJHUB_MGMT_WORKERS

  • ID — int(11) — Primary key — NOT NULL
  • WORKER_ID — varchar(20) — Primary key — NOT NULL — 관계자코드
  • PROJ_ID — varchar(20) — Foreign key → PROJHUB_MGMT_PROJ.PROJ_ID — NOT NULL — 공사코드
  • WORKER_PHONE — varchar(13) — 전화번호
  • WORKER_NAME — varchar(45) — 담당자
  • USER_TYPE — varchar(10) — 사용자유형
  • COMPANY_NAME — varchar(60) — 업체명
  • CONSTRUCT_NAME — varchar(60) — 공종
  • KAKAO_AUTH — varchar(15) — 카톡인증\n카카오플러스의 user_key
  • APP_AUTH — varchar(13) — 앱인증여부\n기기 전화번호
  • CREATED_DT — timestamp
  • ETC — varchar(10)

PROJHUB_USERS

  • USER_PHONE — varchar(13) — Primary key — NOT NULL
  • USER_PW — varchar(150)
  • DEVICE_TOKEN — varchar(200)
  • APP_STATE — varchar(15)
  • ACTIVE_PROJ_ID — varchar(20)

PROJHUB_USER_AUTH

  • USER_PHONE — varchar(13) — Primary key — NOT NULL
  • AUTH_KEY — varchar(6)

PROJHUB_WEB_DETAIL

  • PROJ_ID — varchar(25) — Primary key — NOT NULL
  • USER_PHONE — varchar(13) — NOT NULL
  • JSON_DATA — longtext
  • CREATED_DT — timestamp

PROJHUB_WEB_DETAIL_EACH

  • DETAIL_ID — varchar(20) — NOT NULL
  • USER_PHONE — varchar(13) — NOT NULL
  • PROJ_ID — varchar(25) — NOT NULL
  • DETAIL_TITLE — varchar(255) — NOT NULL — 명칭
  • DETAIL_STANDARD — varchar(255) — 규격
  • DETAIL_UNIT — varchar(30) — 단위
  • DETAIL_CURRENCY — varchar(3) — 통화
  • DETAIL_QTY — double — 수량
  • MATERIAL_UNIT_PRICE — double — 재료비단가
  • MATERIAL_PRICE — double — 재료비금액
  • LABOR_UNIT_PRICE — double — 노무비단가
  • LABOR_PRICE — double — 노무비금액
  • EXPENSE_UNIT_PRICE — int(11) — 경비단가
  • EXPENSE_PRICE — int(11) — 경비금액
  • WORKER_ID — varchar(20) — 담당회사(Worker테이블의 ETC)
  • STANDARD_CODE — varchar(20) — 표준코드
  • DEPTH — int(11)
  • CATEGORY — tinyint(1) — 카테고리여부(1:카테고리)
  • ACTIVITY_TITLE — varchar(50) — 연결된 액티비티의 이름
  • PARENT — varchar(20)

PROJHUB_WEB_TODO

  • TODO_WEB_ID — varchar(45) — Primary key — NOT NULL — ex:todo-web-0
  • ID — int(11) — Primary key — NOT NULL
  • TODO_CODE — varchar(30)
  • TODO_ID — varchar(45) — ex:todo-mgmt-0
  • TODO_DETAIL_ID — varchar(45) — ex:todo-detail-0
  • TODO_PLAN_PRICE — double — 계획금액
  • TODO_REAL_PRICE — double — 실적금액
  • TODO_PROGRESS — double — 진도
  • REAL_START — date — 실제착수일
  • TODO_PLAN_PERIOD — int(11) — 계획공기
  • TODO_REAL_PERIOD — int(11) — 잔여공기