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) — 잔여공기