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