PTC-PM

Tables (48)

accounting_code_tbl

  • id — int(11) — Primary key — NOT NULL
  • Fcode — varchar(4) — Primary key — NOT NULL
  • Ftype — varchar(10) — NOT NULL
  • Fmenu — varchar(20) — NOT NULL
  • Fcategory — varchar(30)
  • priority — int(11) — NOT NULL

accounting_input_tbl

  • id — int(11) — Primary key — NOT NULL
  • AccKind — varchar(10)
  • AccCode — varchar(10)
  • VendorType — varchar(10)
  • VendorCode — varchar(20)
  • VendorName — varchar(50)
  • AccSubstance — varchar(200)
  • Amount — double
  • Vat — double
  • GroupCode — varchar(10)
  • ProjectCode — varchar(50)
  • AmountKind — varchar(20)
  • TaxNo — varchar(50)
  • MemberNo — varchar(10)
  • AmountDate — date
  • Note — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)
  • claimdate — date
  • billdate — date
  • DepartAccCode — varchar(5)
  • buy_money — double
  • buy_vat — double
  • buy_amount — double
  • expense_duedate — date
  • expense_amount — double
  • ProjectNickName — varchar(150)
  • DepartAccName — varchar(50)
  • AccName — varchar(50)
  • ContractStep — varchar(10)

change_list_tbl

  • ProjectCode — varchar(15) — NOT NULL
  • Division — varchar(50)
  • ChangeDate — date — NOT NULL
  • ChangeItem — varchar(30) — NOT NULL
  • ChangeBefore — varchar(50)
  • ChangeAfter — varchar(50)
  • Note — varchar(100)
  • No — int(11)
  • UpdateDate — datetime
  • UpdateUser — varchar(20)

collection_expense_tbl

  • ProjectCode — varchar(15)
  • no — int(3)
  • Pay — double

collectionpayment_tbl

  • ProjectCode — varchar(15) — NOT NULL
  • ContractStep — varchar(10)
  • Kind — varchar(10)
  • DemandDate — date
  • CollectionDate — date
  • Collection_Duedate — date
  • CollectionPayment — double
  • TypePayment — varchar(20)
  • Note — varchar(255)
  • No — int(11)
  • UpdateDate — datetime
  • UpdateUser — varchar(20)
  • PaymentCompany — varchar(100)
  • CollPaymentType — varchar(10)
  • BillDate — date
  • BillInputDate — date
  • BillExpiryDate — date
  • BillBank — varchar(50)
  • BillDiscountDate — date
  • BillDiscountAmount — double
  • BillDiscountRate — varchar(100)
  • IncomAmount — double
  • BillAmount — double
  • DemandSendDate — date
  • sales_duedate — date
  • sales_money — double
  • sales_vat — double
  • sales_amount — double
  • sales_meno — varchar(255)
  • receive_money — double
  • receive_vat — double
  • receive_status — varchar(255)
  • filename — varchar(255)
  • accountno — varchar(255)
  • accountid — int(11)

collectionpaymentplan_tbl

  • ProjectCode — varchar(15)
  • PlanDateKey — varchar(15)
  • PaymentDate — date
  • CollectionPayment — double
  • Note — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(20)

config_tbl

  • category — varchar(50)
  • category_sub — varchar(50)
  • name — varchar(50)
  • code — varchar(5)
  • priority — int(5)
  • desc — varchar(200)

consumption_loan_tbl

  • id — int(11) — Primary key — NOT NULL
  • ProjectName — varchar(100) — NOT NULL
  • Company — varchar(50)
  • PaymentDate — varchar(50)
  • Amount — varchar(50)
  • ExpectedDate — varchar(50)
  • Note — varchar(255)
  • UpdateDate — varchar(50)

daily_conf_tbl

  • index_no — bigint(20) — Primary key — NOT NULL
  • ProjectCode — varchar(15)
  • progress_no — int(2)
  • kind — varchar(50)
  • item — varchar(100)
  • standard — varchar(200)
  • unit — varchar(10)
  • start_date — date
  • end_date — date
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

daily_memo_tbl

  • ProjectCode — varchar(255)
  • progress_no — int(5)
  • WorkDate — date
  • Today_Doc — text
  • Plan_Doc — text
  • Conference_Doc — text
  • Remarks_Doc — varchar(255)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

daily_work_tbl

  • ProjectCode — varchar(255)
  • progress_no — int(2)
  • WorkDate — date
  • kind — varchar(100)
  • conf_index — bigint(20)
  • WorkValue — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

member_tbl

  • MemberNo — varchar(15) — Primary key — NOT NULL
  • korName — varchar(14) — Primary key — NOT NULL
  • Pasword — varchar(15)
  • RankCode — varchar(5)
  • GroupCode — int(11)
  • WorkPosition — int(10)
  • chiName — varchar(14)
  • engName — varchar(30)
  • Degree — varchar(20)
  • Technical — varchar(20)
  • ExtNo — int(11)
  • EntryDate — date
  • LeaveDate — date
  • JuminNo — varchar(20)
  • Phone — varchar(20)
  • Mobile — varchar(20)
  • eMail — varchar(30)
  • OrignAddress — varchar(100)
  • ZipCode — varchar(10)
  • Address — varchar(100)
  • Author — varchar(200)
  • Certificate — varchar(100)
  • Meritorious — int(11)
  • Disabled — int(11)
  • UpdateDate — datetime
  • UpdateUser — varchar(14)
  • Show_Insa — varchar(4)
  • RegStDate — date
  • RegEdDate — date
  • Engineer — varchar(10)
  • HeadType — varchar(20)
  • Company — varchar(10)
  • WorkCompany — varchar(10)
  • EntryType — varchar(5)
  • LeaveReason — varchar(5)
  • married — varchar(20)
  • vacation — int(1)
  • birthday — date
  • BirthdayType — int(10)
  • BirthdayViewYn — int(10) — 메인화면 생일노출여부(노출:1/미노출:0)
  • originalbirthday — date
  • office_type — int(1)
  • IntranetVer — varchar(10)
  • ViewRankName — varchar(10)
  • UserInfoPW — varchar(15)

payment_voucher_tbl

  • id — int(11) — Primary key — NOT NULL
  • no — int(2)
  • kind — int(2)
  • ProjectCode — varchar(50)
  • ProjectName — varchar(200)
  • AccSubstance — varchar(250)
  • DepartAccMenu — varchar(50)
  • DepartAccCode — varchar(50)
  • DepartAccName — varchar(50)
  • VendorType — varchar(10)
  • VendorCode — varchar(20)
  • VendorName — varchar(50)
  • claimdate — date
  • billdate — date
  • Substance_detail — varchar(250)
  • Substance_detail2 — varchar(250)
  • etc1 — varchar(250)
  • etc2 — varchar(250)
  • etc3 — varchar(250)
  • etc4 — varchar(250)
  • etc5 — varchar(250)
  • etc6 — varchar(250)
  • etc7 — varchar(250)
  • GroupCode — varchar(20)
  • GroupName — varchar(50)
  • maker — varchar(15)
  • makerKor — varchar(15)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)
  • buy_money — double
  • buy_vat — double
  • buy_amount — double
  • buy_amountKor — varchar(250)
  • buy_amount2 — double
  • proof_doc — text
  • account_no — bigint(20)
  • input_id — int(11)
  • expense_duedate — date
  • expensedate — date
  • ContractStep — varchar(10)

project_combidetail_tbl

  • index_no — bigint(20) — Primary key — NOT NULL
  • ProjectCode — varchar(15)
  • progress_no — char(3)
  • kind — varchar(50)
  • diameter — varchar(10)
  • thickness — varchar(5)
  • steel_grade — varchar(20)
  • length — double
  • pilesnum — varchar(20)
  • structure — varchar(255)
  • PHC_type — varchar(50)
  • start_date — date
  • end_date — date
  • phc_diameter — varchar(10)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_combination_new_tbl

  • index_no — bigint(20) — Primary key — NOT NULL
  • ProjectCode — varchar(15)
  • progress_no — char(3) — 시공차수
  • bridgename — varchar(50) — 교량명
  • direction — varchar(20) — 방향
  • location — varchar(10) — 위치
  • diameter — varchar(10) — 직경
  • thickness — varchar(5) — 두께
  • steel_grade — varchar(20) — 강종
  • pile_length — varchar(10) — 설계길이
  • testpile_ea — varchar(10) — 시항타 수량(본)
  • pile_ea — varchar(10) — 본항타 수량(본)
  • test_L1_length — varchar(10) — 시항타 강관길이
  • L1_length — varchar(10) — 본항타 강관길이
  • test_phc_length — varchar(10) — 시항타 PHC길이
  • phc_length — varchar(10) — 본항타 PHC길이
  • test_sum_length — varchar(10) — 시항타 발주길이 합계
  • sum_length — varchar(10) — 본항타 발주길이 합계
  • phc_type — char(2) — PHC TYPE
  • test_phc_diameter — varchar(10) — 시항타 DDH PHC직경
  • phc_diameter — varchar(10) — 본항타 DDH PHC직경
  • test_connect_type — varchar(10) — 시항타 DDH 연결구 종류
  • connect_type — varchar(10) — 본항타 DDH 연결구 종류
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_combination_rsw_tbl

  • index_no — bigint(20) — Primary key — NOT NULL
  • ProjectCode — varchar(15)
  • progress_no — char(3)
  • location — varchar(50)
  • materials — varchar(10)
  • standard — varchar(10)
  • pile_length — varchar(10)
  • pile_ea — varchar(10)
  • remark — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_condition_tbl

  • ProjectCode — varchar(255) — Primary key — NOT NULL
  • contract_no — int(2) — Primary key — NOT NULL
  • Estimate_1 — varchar(255)
  • Estimate_2 — varchar(255)
  • Estimate_3 — varchar(255)
  • Estimate_4 — varchar(255)
  • Estimate_5 — varchar(255)
  • Estimate_6 — varchar(255)
  • Estimate_7 — varchar(255)
  • Estimate_8 — varchar(255)
  • Estimate_9 — varchar(255)
  • Estimate_10 — varchar(255)
  • Estimate_11 — varchar(255)
  • Estimate_12 — varchar(255)
  • Contract_1 — varchar(255)
  • Contract_2 — varchar(255)
  • Contract_3 — varchar(255)
  • Contract_4 — varchar(255)
  • Contract_5 — varchar(255)
  • Contract_6 — varchar(255)
  • Contract_7 — varchar(255)
  • Contract_8 — varchar(255)
  • Contract_9 — varchar(255)
  • Contract_10 — varchar(255)
  • Contract_11 — varchar(255)
  • Contract_12 — varchar(255)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_confer_tbl

  • conf_no — bigint(20) — Primary key — NOT NULL
  • projectcode — varchar(15)
  • config_code — varchar(5)
  • conf_date — date
  • our_name — varchar(20)
  • opponent_name — varchar(20)
  • contents — text
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_conference_tbl

  • ProjectCode — varchar(15) — NOT NULL — 영업코드
  • conferencerow — int(11) — 줄번호
  • conferencedate — date — 날짜
  • name — varchar(100) — 담당
  • statusmemo — varchar(100) — 상태
  • contents — varchar(255) — 내용
  • note — text — 비고
  • UpdateDate — datetime — 수정_시간
  • UpdateUser — varchar(15) — 수정_사용자

project_contract_tbl

  • ProjectCode — varchar(15) — Primary key — NOT NULL
  • contract_no — int(10) — Primary key — NOT NULL
  • designcode — varchar(15)
  • ProjectName — varchar(100)
  • ProjectNickname — varchar(30)
  • WorkStatus — varchar(20)
  • Contractor — varchar(255)
  • WorkLocation — varchar(100)
  • OrderCompany — varchar(100)
  • OrgContract — varchar(50)
  • KindOrderCompany — varchar(30)
  • Order_Date — date
  • Order_Range — varchar(255)
  • Order_Form — varchar(255)
  • ContractDate — date
  • ContractStart — date
  • ContractEnd — date
  • TermsPayment — varchar(255)
  • PaymentDeadline — varchar(255)
  • person — varchar(15)
  • Order_Stand — varchar(255)
  • Order_Length — varchar(255)
  • Order_Ea — varchar(255)
  • OrgContractPayment — double
  • ContractPayment — double
  • Payment — double
  • Vat — double
  • ExcutivePayment — double
  • memo — text
  • Construction_name — varchar(255)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_cs_designqty_tbl

  • id — int(11) — Primary key — NOT NULL
  • ProjectCode — varchar(20)
  • BridgeNo — int(11)
  • WorkType — varchar(10)
  • ConstructionMethod — varchar(50)
  • Position — varchar(50)
  • PositionName — varchar(20)
  • Quantity — double
  • QuantityA — double
  • QuantityB — double
  • QuantityC — double
  • QuantityD — double
  • M2Quantity — double
  • M2QuantityA — double
  • M2QuantityB — double
  • M2QuantityC — double
  • StartDate — date
  • EndDate — date
  • Term — int(11)
  • PreparationCnt — int(11)
  • WorkCnt — int(11)
  • HolydayCnt — int(11)
  • FormIn — int(11)
  • GirderHeight — double
  • SpanLength — varchar(100)
  • WorkManager — varchar(30)
  • WorkPerson — varchar(30)
  • FactorySteel — double
  • FieldSteel — double
  • Note — varchar(200)
  • UpdateDate — datetime
  • UpdateUser — varchar(50)

project_cs_qty_tbl

  • id — int(11) — Primary key — NOT NULL
  • ProjectCode — varchar(20)
  • No — int(11)
  • QtyCode — varchar(10)
  • QtyCS — double
  • WorkDate — date
  • UpdateDate — datetime
  • UpdateUser — varchar(50)

project_cs_summary_tbl

  • Item_no — int(11) — Primary key — NOT NULL
  • ProjectCode — varchar(15)
  • no — int(11)
  • Item — varchar(20)
  • ConstructionMethod — varchar(10)
  • Value — varchar(40)
  • Value_revers — varchar(40)
  • Width — varchar(20)
  • Width_revers — varchar(20)
  • SpanLength — varchar(20)
  • Height — varchar(20)
  • Height_special — varchar(20)
  • Unit — varchar(10)
  • Girder — int(11)
  • CrossBeams — int(11)
  • Pannel — int(11)
  • SteelReinforcement — int(11)
  • ConstructionDate — date
  • Note — varchar(100)
  • Welding — int(11)
  • SteelWelding — int(11)
  • MakeEtc — varchar(254)
  • MakeDetail — varchar(254)
  • ProcessEtc — varchar(400)
  • ProcessDetail — varchar(254)
  • UpdateDate — datetime
  • UpdateUser — varchar(50)
  • Height2 — varchar(20)
  • Height3 — varchar(20)
  • Pannel2 — int(11)
  • Pannel3 — int(11)
  • Value2 — varchar(40)
  • Value2_revers — varchar(40)
  • CSManager — varchar(20)
  • MakeManager — varchar(20)
  • TensileManager — varchar(20)
  • ConstructionState — int(10)
  • CompletDate — date
  • MakeAreaDate — date
  • GirderMakeDate — date
  • doc_location — varchar(254)
  • afterservice — int(2)
  • address — varchar(254)
  • item_address — varchar(254)
  • lat_coordinate — varchar(50)
  • lng_coordinate — varchar(50)
  • ReflectionDate — date
  • beforeItem_no — int(11)
  • upside — varchar(50)
  • downside — varchar(50)

project_design_apply_tbl

  • design_step — int(3)
  • design_date — date
  • no — int(11)
  • designcode — varchar(15)
  • bridgename — varchar(50)
  • direction — varchar(20)
  • location — varchar(50)
  • apply_method — char(2)
  • diameter — varchar(10)
  • thickness — varchar(5)
  • steel_grade — varchar(20)
  • pile_length — varchar(10)
  • pile_ea — varchar(10)
  • L1_length — varchar(10)
  • L2_length — varchar(10)
  • PHC_length — varchar(10)
  • total_length — varchar(10)
  • ordernum — int(2)
  • note — varchar(255)
  • writer — varchar(20)
  • reviewer — varchar(20)
  • design_price — double
  • structure — varchar(100)
  • phc_diameter — varchar(10)
  • phc_kind — varchar(10)
  • connect_type — varchar(10)
  • connect_height — varchar(10)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_design_code_tbl

  • SysKey — varchar(30)
  • Methoid — varchar(50)
  • Code — varchar(10)
  • Name — varchar(50)
  • Standard — varchar(50)
  • Unit — varchar(250)
  • Note — varchar(250)
  • orderno — int(11)

project_design_constructcontact_tbl

  • designcode — varchar(15) — Primary key — NOT NULL
  • order_name — varchar(50)
  • order_phone — varchar(50)
  • order_name2 — varchar(50)
  • order_phone2 — varchar(50)
  • order_name3 — varchar(50)
  • order_phone3 — varchar(50)
  • construct — varchar(50)
  • construct_name1 — varchar(50)
  • construct_phone1 — varchar(50)
  • construct_name2 — varchar(50)
  • construct_phone2 — varchar(50)
  • construct_name3 — varchar(50)
  • construct_phone3 — varchar(50)
  • inspection — varchar(50)
  • inspection_name1 — varchar(50)
  • inspection_phone1 — varchar(50)
  • inspection_name2 — varchar(50)
  • inspection_phone2 — varchar(50)
  • inspection_name3 — varchar(50)
  • inspection_phone3 — varchar(50)
  • inspection_name4 — varchar(50)
  • inspection_phone4 — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_design_designcontact_tbl

  • designcode — varchar(15)
  • kind — varchar(10)
  • company — varchar(100)
  • pm_name — varchar(100)
  • pm_phone — varchar(100)
  • person_name — varchar(100)
  • person_phone — varchar(100)
  • company2 — varchar(100)
  • pm_name2 — varchar(100)
  • pm_phone2 — varchar(100)
  • person_name2 — varchar(100)
  • person_phone2 — varchar(100)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_design_history_tbl

  • history_no — bigint(20) — Primary key — NOT NULL
  • designcode — varchar(15)
  • mettingkind — varchar(10)
  • mettingdate — date
  • person — varchar(15)
  • opposite — varchar(50)
  • content — text
  • mettingtype — int(1)
  • memo — varchar(250)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_design_progress_tbl

  • designcode — varchar(15)
  • kind — int(1)
  • plandate — date
  • completedate — date
  • result — text
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_design_tbl

  • designcode — varchar(15) — Primary key — NOT NULL
  • designstate — int(1)
  • designname — varchar(255)
  • designnickname — varchar(255)
  • serviceperiod — varchar(100)
  • ordercompany — varchar(100)
  • designkind — int(1)
  • receiptdate — date
  • hcpapplydate — date
  • send_date — date
  • note — text
  • design_width — varchar(255)
  • soil_map — varchar(1)
  • filename — text
  • check_design1 — int(10)
  • check_design2 — int(10)
  • check_design3 — int(10)
  • check_design4 — int(10)
  • materials_cost — double
  • materials_note — varchar(255)
  • boring_cost — double
  • boring_note — varchar(255)
  • product_kind — varchar(1)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_expense_plan_tbl

  • ProjectCode — varchar(15)
  • outdate — date
  • amount — double
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_methodkind_tbl

  • ProjectCode — varchar(15) — NOT NULL — 영업코드
  • methodrow — int(11) — 줄번호
  • product_kind — varchar(255) — 공법현황
  • name — varchar(100) — 구조물명
  • number — varchar(100) — 본수
  • diameter — varchar(255) — 직경
  • pipelength — varchar(100) — 강관길이
  • thickness — varchar(100) — 두께
  • offermoney — varchar(50) — 제안금액
  • lengths2 — varchar(100)
  • lengths — varchar(100) — 길이
  • standards — varchar(100)
  • applyYN — varchar(100) — 신청여부
  • note — text — 비고
  • UpdateDate — datetime — 수정_시간
  • UpdateUser — varchar(30) — 수정_사용자

project_progress_tbl

  • ProjectCode — varchar(15)
  • progress_no — int(2)
  • standard — varchar(10)
  • ea — int(50)
  • length — varchar(50)
  • method — varchar(50)
  • Piling — varchar(100)
  • order_date — date
  • start_date — date
  • end_date — date
  • field_agent — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_sale_tbl

  • salecode — varchar(15) — Primary key — NOT NULL — 영업코드
  • salestate — int(1)
  • salename — varchar(255) — 사업명
  • salenickname — varchar(255) — 약칭
  • servicename — varchar(100) — 용역사
  • serviceoffice — varchar(100) — 영업사
  • ordercompany — varchar(100) — 발주처
  • WorkLocation — varchar(100) — 지역
  • proposaldate — date — 제안서 제출일자
  • constructiondate — date — 공법심의 일자
  • note — text — 메모
  • product_kind — varchar(10) — 공법현황
  • product_kind2 — varchar(10) — 공법종류
  • product_kind3 — varchar(10) — 공법사 발표
  • product_kind4 — varchar(10) — 서면심의
  • product_kind5 — varchar(10)
  • product_kind6 — varchar(10)
  • agreementstate — varchar(10) — 협약체결(0:- ,1:○)
  • saledata — varchar(255) — 첨부파일
  • memo — text — 비고
  • patentTech — varchar(255)
  • UpdateDate — datetime — 수정일자
  • UpdateUser — varchar(15) — 수정사용자

project_salemanager_tbl

  • ProjectCode — varchar(15) — NOT NULL — 영업코드
  • managernum — int(1) — 줄번호
  • managerdeptrank — varchar(255) — 소속/직책
  • managername — varchar(100) — 이름
  • managerphone — varchar(100) — 연락처등
  • manager — varchar(255) — 담당자
  • note — text — 비고
  • UpdateDate — datetime — 수정_시간
  • UpdateUser — varchar(15) — 수정_사용자

project_sales_tbl

  • ProjectCode — varchar(15)
  • sales_no — int(3)
  • ContractStep — varchar(2)
  • HCP_cost — double
  • steel_cost — double
  • PHC_cost — double
  • materials_sum_cost — double
  • construction_cost — double
  • pilecap_cost — double
  • testing_cost — double
  • indirect_cost — double
  • total_cost — double
  • design_width — varchar(10)
  • soil_map — varchar(1)
  • filename — varchar(255)
  • product_kind — varchar(1)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_schedule_tbl

  • no — bigint(20) — Primary key — NOT NULL
  • ProjectName — varchar(255)
  • OrderCompany — varchar(255)
  • structure — varchar(255)
  • length — varchar(50)
  • ea — varchar(50)
  • duedate — varchar(255)
  • orderdate — varchar(255)
  • putdate — varchar(255)
  • testdate — varchar(255)
  • product_kind — varchar(1)

project_staff_tbl

  • id — int(11) — Primary key — NOT NULL
  • ProjectCode — varchar(20)
  • BridgeNo — int(11)
  • Process — varchar(4)
  • Name — varchar(20)
  • Status — varchar(20)
  • StartDate — date
  • EndDate — date
  • UpdateDate — datetime
  • UpdateUser — varchar(20)
  • Note — varchar(100)

project_statement_tbl

  • ProjectCode — varchar(15)
  • contract_no — int(3)
  • HCP_cost — double
  • steel_cost — double
  • PHC_cost — double
  • materials_sum_cost — double
  • construction_cost — double
  • pilecap_cost — double
  • testing_cost — double
  • indirect_cost — double
  • total_cost — double
  • filename — varchar(255)
  • UpdateDate — datetime
  • UpdateUser — varchar(15)

project_tbl

  • ProjectCode — varchar(15)
  • oldProjectCode — varchar(15)
  • oldProjectCode2 — varchar(15)
  • ProjectName — varchar(255)
  • ProjectNickname — varchar(255)
  • OrderCompany — varchar(100)
  • OrderNickname — varchar(30)
  • ContractDate — date
  • ContractStart — date
  • ContractEnd — date
  • ContractPeriod — int(11)
  • WorkStatus — varchar(20)
  • OrgContractPayment — double
  • ContractPayment — double
  • Payment — double
  • Vat — double
  • CommonCompany — varchar(50)
  • ContractRatio — double
  • ActualityRatio — double
  • MainGroup — varchar(30)
  • Name — varchar(15)
  • ContractSeal — varchar(6)
  • Note — varchar(250)
  • KindOrderCompany — varchar(30)
  • Part — varchar(30)
  • DesignStep — varchar(30)
  • UpdateDate — datetime
  • UpdateUser — varchar(20)
  • year — int(11)
  • OrgProjectName — varchar(100)
  • OrgProjectNickname — varchar(30)
  • WorkLocation — varchar(100)
  • OrgContract — varchar(50)
  • SubContract — varchar(50)
  • TermsPayment — varchar(20)
  • TypePayment — varchar(20)
  • Bonds — double
  • CSManager — varchar(20)
  • CSAgent — varchar(20)
  • ContractDeposit — double
  • ContractWarranty — varchar(20)
  • ASDeposit — double
  • ASWarranty — varchar(20)
  • DelayRatio — double
  • ConstructionMethod — varchar(10)
  • DesignPrice — double
  • DesignAccept — varchar(10)
  • salescode — varchar(15)
  • Order_Ea — varchar(100)
  • Order_Range — varchar(100)
  • PaymentDeadline — varchar(255)
  • maker — varchar(15)
  • makedate — date
  • orderNote — text
  • product_kind — varchar(50)

project_temporary_pay_tbl

  • ProjectNo — int(11)
  • PlanDateKey — varchar(15)
  • PaymentDate — date
  • CollectionPayment — double
  • Note — varchar(50)
  • UpdateDate — datetime
  • UpdateUser — varchar(20)

project_temporary_tbl

  • ProjectNo — int(11) — Primary key — NOT NULL
  • Projectname — varchar(255)
  • OrgContract — varchar(255)
  • Constructor — varchar(255)
  • ContractPay — double
  • memo — text
  • UpdateDate — datetime
  • UpdateUser — varchar(50)

project_tmpea_tbl

  • ProjectCode — varchar(15)
  • 2008 — varchar(10)
  • 2009 — varchar(10)
  • 2010 — varchar(10)
  • 2011 — varchar(10)
  • 2012 — varchar(10)

systemconfig_tbl

  • SysKey — varchar(30)
  • Code — varchar(20)
  • Name — varchar(50)
  • CodeORName — varchar(50)
  • Description — varchar(250)
  • Note — varchar(250)
  • orderno — int(10)

view_change_list_tbl

  • ProjectCode — VARCHAR(1) — NOT NULL
  • Division — VARCHAR(1)
  • ChangeDate — DATE — NOT NULL
  • ChangeItem — VARCHAR(1) — NOT NULL
  • ChangeBefore — VARCHAR(1)
  • ChangeAfter — VARCHAR(1)
  • Note — VARCHAR(1)
  • No — INT(11)
  • UpdateDate — DATETIME
  • UpdateUser — VARCHAR(1)
  • product_kind — VARCHAR(1)

view_collectionpayment_tbl

  • ProjectCode — VARCHAR(1) — NOT NULL
  • ContractStep — VARCHAR(1)
  • Kind — VARCHAR(1)
  • DemandDate — DATE
  • CollectionDate — DATE
  • Collection_Duedate — DATE
  • CollectionPayment — DOUBLE
  • TypePayment — VARCHAR(1)
  • Note — VARCHAR(1)
  • No — INT(11)
  • UpdateDate — DATETIME
  • UpdateUser — VARCHAR(1)
  • PaymentCompany — VARCHAR(1)
  • CollPaymentType — VARCHAR(1)
  • BillDate — DATE
  • BillInputDate — DATE
  • BillExpiryDate — DATE
  • BillBank — VARCHAR(1)
  • BillDiscountDate — DATE
  • BillDiscountAmount — DOUBLE
  • BillDiscountRate — VARCHAR(1)
  • IncomAmount — DOUBLE
  • BillAmount — DOUBLE
  • DemandSendDate — DATE
  • sales_duedate — DATE
  • sales_money — DOUBLE
  • sales_vat — DOUBLE
  • sales_amount — DOUBLE
  • sales_meno — VARCHAR(1)
  • receive_money — DOUBLE
  • receive_vat — DOUBLE
  • receive_status — VARCHAR(1)
  • filename — VARCHAR(1)
  • product_kind — VARCHAR(1)
  • accountno — VARCHAR(1)

view_daily_work_tbl

  • ProjectCode — VARCHAR(1)
  • WorkValue — VARCHAR(1)
  • product_kind — VARCHAR(1)
  • WorkDate — DATE
  • kind — VARCHAR(1)

view_project_cs_qty_tbl

  • WorkDate — VARBINARY(7)
  • WorkValue2 — DOUBLE