427 lines
25 KiB
Plaintext
427 lines
25 KiB
Plaintext
generator client {
|
|
provider = "prisma-client-js"
|
|
previewFeatures = ["views"]
|
|
}
|
|
|
|
datasource db {
|
|
provider = "mysql"
|
|
url = env("DATABASE_URL")
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model dingding_oa_invoice_application {
|
|
invoiceJobNumber Int @default(autoincrement())
|
|
dataId String @db.VarChar(255)
|
|
applicationDate String? @db.VarChar(255)
|
|
applicant String? @db.VarChar(255)
|
|
applicationDepartment String? @db.VarChar(255)
|
|
agreementType String? @db.VarChar(255)
|
|
xiang_mu_zu_bie String? @db.VarChar(255)
|
|
yuJiBaoXiaoDiSanFangChengBenYuan String? @db.VarChar(255)
|
|
businessStartTime String? @db.VarChar(255)
|
|
businessEndTime String? @db.VarChar(255)
|
|
contractNumber String? @db.VarChar(255)
|
|
contractName String? @db.VarChar(255)
|
|
uploadedContractAttachment String? @db.Text
|
|
uploadedSealedCostListDa String? @db.Text
|
|
uploadedSealedCostListDu String? @db.Text
|
|
projectNumber String? @db.VarChar(255)
|
|
is_tax_inclusive String? @db.VarChar(255)
|
|
invoice_tax_rate String? @db.VarChar(255)
|
|
invoice_tax_category String? @db.VarChar(255)
|
|
is_multi_project_merge String? @db.VarChar(255)
|
|
customerCompanyName String? @db.VarChar(255)
|
|
customerCompanyNameOther String? @db.VarChar(255)
|
|
tong_yi_she_hui_xin_yong_dai_ma String? @db.VarChar(255)
|
|
bankName String? @db.VarChar(255)
|
|
bankAccount String? @db.VarChar(255)
|
|
kai_piao_shi_you String? @db.VarChar(255)
|
|
fa_piao_bei_zhu_lan_tian_xie_nei_rong String? @db.Text
|
|
invoiceType String? @db.VarChar(50)
|
|
invoiceCode Int? @db.UnsignedTinyInt
|
|
business_content_du String? @db.VarChar(255)
|
|
invoice_amount_yuan_du String? @db.VarChar(255)
|
|
invoice_amount_yuan_other String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
user String? @db.VarChar(255)
|
|
remark String? @db.VarChar(255)
|
|
cancelReason String? @db.VarChar(255)
|
|
canceldataid String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da String? @db.VarChar(255)
|
|
han_shui_zong_jin_e_yuan_da String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
han_shui_zong_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_du_da_xie String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_other_da_xie String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_other_da_xie String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_duo_da_xie String? @db.VarChar(255)
|
|
approvalNumber String? @db.VarChar(255)
|
|
creationTime String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
currentResponsiblePerson String? @db.VarChar(255)
|
|
approvalResult String? @db.VarChar(255)
|
|
approvalStatus String? @db.VarChar(255)
|
|
updateTime String? @db.VarChar(255)
|
|
creatorDepartment String? @db.VarChar(255)
|
|
approvalFormTitle String? @db.VarChar(255)
|
|
historicalApprovers String? @db.VarChar(255)
|
|
timeConsumed String? @db.VarChar(255)
|
|
approvalRecord String? @db.VarChar(255)
|
|
payee String? @db.VarChar(255)
|
|
invoice_amount_yuan String? @db.VarChar(255)
|
|
invoice_amount_yuan_da String? @db.VarChar(255)
|
|
BigInvoiceAmountList String? @db.Text
|
|
multiProjectMergeInvoice String? @db.Text
|
|
is_single_contract_multi_customer String? @db.VarChar(255)
|
|
single_contract_multi_customer_invoice_list String? @db.Text
|
|
hong_chong_piao_hao String? @db.VarChar(50)
|
|
|
|
@@id([invoiceJobNumber, dataId])
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model invoice_amount_details {
|
|
id Int @default(autoincrement())
|
|
dataid String @db.VarChar(255)
|
|
agreementType String? @db.VarChar(50)
|
|
project_number String? @db.VarChar(255)
|
|
business_group_name String? @db.VarChar(100)
|
|
project_name String? @db.VarChar(255)
|
|
customer_company_name String? @db.VarChar(255)
|
|
tong_yi_she_hui_xin_yong_dai_ma String? @db.VarChar(255)
|
|
bank_name String? @db.VarChar(255)
|
|
bank_account String? @db.VarChar(255)
|
|
business_content String? @db.VarChar(255)
|
|
invoice_amount String? @db.VarChar(255)
|
|
payee String? @db.VarChar(255)
|
|
updatedAt DateTime @default(now()) @db.DateTime(0)
|
|
yu_ji_bao_xiao_di_san_fang_cheng_ben String? @db.VarChar(255)
|
|
|
|
@@id([id, dataid])
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model invoice_data {
|
|
dataid String @db.VarChar(255)
|
|
piao_hao String @id @db.VarChar(50)
|
|
kai_piao_ri_qi String @db.VarChar(50)
|
|
hui_kuan_ri_qi String @db.VarChar(255)
|
|
hui_kuan_jin_e String @db.VarChar(255)
|
|
created_at DateTime @default(now()) @db.DateTime(0)
|
|
updated_at DateTime @default(now()) @db.DateTime(0)
|
|
invoice_type_enum Int? @default(0)
|
|
zhang_qi String? @db.VarChar(255)
|
|
customer_company_name String? @db.VarChar(255)
|
|
}
|
|
|
|
model test {
|
|
id Int @id
|
|
name String? @db.VarChar(255)
|
|
shcool String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model project {
|
|
data_id String @id @db.VarChar(255)
|
|
project_department String? @db.VarChar(255)
|
|
is_multi_client String? @db.VarChar(255)
|
|
multi_client_name String? @db.VarChar(255)
|
|
group_abbreviation String? @db.VarChar(255)
|
|
previous_project_id String? @db.VarChar(255)
|
|
project_id String? @db.VarChar(255)
|
|
project_name String? @db.VarChar(255)
|
|
contract_id String? @db.VarChar(255)
|
|
contract_name String? @db.VarChar(255)
|
|
client_name String? @db.VarChar(255)
|
|
unit_nature String? @db.VarChar(255)
|
|
project_leader String? @db.VarChar(255)
|
|
create_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_title String? @db.VarChar(255)
|
|
update_time String? @db.VarChar(255)
|
|
project_group String? @db.VarChar(255)
|
|
delivery_area String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model purchase_contract_order_management {
|
|
data_id String @id @db.VarChar(255)
|
|
purchase_contract_number String? @db.VarChar(255)
|
|
purchase_purpose String? @db.VarChar(255)
|
|
project_number String? @db.VarChar(255)
|
|
project_name String? @db.VarChar(255)
|
|
associated_sales_contract_number String? @db.VarChar(255)
|
|
contract_name String? @db.VarChar(255)
|
|
purchase_approval_number String? @db.VarChar(255)
|
|
purchase_contract_name String? @db.VarChar(255)
|
|
xiang_dui_fang String? @db.VarChar(255)
|
|
he_tong_lei_bie String? @db.VarChar(255)
|
|
he_tong_zong_jin_e_HanShui String? @db.VarChar(255)
|
|
sheng_yu_jin_e_HanShui String? @db.VarChar(255)
|
|
he_tong_sheng_yu_jin_e_ti_xing String? @db.VarChar(255)
|
|
ben_ci_ding_dan_ming_cheng String? @db.VarChar(255)
|
|
ben_ci_ding_dan_jin_e_HanShui String? @db.VarChar(255)
|
|
ben_ci_ding_dan_lu_yue_kai_shi_shi_jian String? @db.VarChar(255)
|
|
ben_ci_ding_dan_lu_yue_jie_shu_shi_jian String? @db.VarChar(255)
|
|
ben_ci_ding_dan_fa_qi_bu_men String? @db.VarChar(255)
|
|
ben_ci_ding_dan_fa_qi_ren String? @db.VarChar(255)
|
|
ben_ci_ding_dan_fa_qi_shi_jian String? @db.VarChar(255)
|
|
ben_ci_ding_dan_guan_lian_he_tong_fujian String? @db.VarChar(255)
|
|
ben_ci_ding_dan_wen_ben String? @db.Text
|
|
approval_number String? @db.VarChar(255)
|
|
creation_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
current_responsible_person String? @db.VarChar(255)
|
|
approval_result String? @db.VarChar(255)
|
|
approval_status String? @db.VarChar(255)
|
|
update_time String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_form_title String? @db.VarChar(255)
|
|
time_consumed String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model purchase_contract_execution_maintenance {
|
|
data_id String @id @db.VarChar(255)
|
|
initiator String? @db.VarChar(255)
|
|
contract_number String? @db.VarChar(255)
|
|
contract_name String? @db.VarChar(255)
|
|
lvyue_faqi_bumen String? @db.VarChar(255)
|
|
operator String? @db.VarChar(255)
|
|
xiangduifang String? @db.VarChar(255)
|
|
is_open String? @db.VarChar(255)
|
|
contract_amount String? @db.VarChar(255)
|
|
remarks String? @db.VarChar(255)
|
|
performance_start_time String? @db.VarChar(255)
|
|
hetong_yuanjian_saomiaojian_gaizhangban String? @db.Text
|
|
contract_attachment_scan String? @db.Text
|
|
dingding_purchase_approval_file String? @db.Text
|
|
creation_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_form_title String? @db.VarChar(255)
|
|
update_time String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model actual_payment {
|
|
data_id String @id @db.VarChar(255)
|
|
project_number String? @db.VarChar(255)
|
|
payment_date String? @db.VarChar(255)
|
|
payment_year String? @db.VarChar(255)
|
|
pingzhenghao String? @db.VarChar(255)
|
|
hangxiangmu_wenben String? @db.VarChar(255)
|
|
business_line String? @db.VarChar(255)
|
|
qimo_yueyuan String? @db.VarChar(255)
|
|
qimo_yueyuan_daxie String? @db.VarChar(255)
|
|
payment_method String? @db.VarChar(255)
|
|
gongyingshang_mingcheng String? @db.VarChar(255)
|
|
created_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_title String? @db.VarChar(255)
|
|
updated_time String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model expense_reimbursement {
|
|
data_id String @id @db.VarChar(255)
|
|
project_number String? @db.VarChar(255)
|
|
reimbursement_time String? @db.VarChar(255)
|
|
category String? @db.VarChar(255)
|
|
project_team String? @db.VarChar(255)
|
|
amount String? @db.VarChar(255)
|
|
sr_number String? @db.VarChar(255)
|
|
baoxiaoren String? @db.VarChar(255)
|
|
suoshu_zhangtao String? @db.VarChar(255)
|
|
baoxiao_yuefen String? @db.VarChar(255)
|
|
baoxiao_nianfen String? @db.VarChar(255)
|
|
expense_type String? @db.VarChar(255)
|
|
gongyingshang_guazhang_mingcheng String? @db.VarChar(255)
|
|
created_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_title String? @db.VarChar(255)
|
|
updated_time String? @db.VarChar(255)
|
|
xuhao String? @db.VarChar(255)
|
|
date String? @db.VarChar(255)
|
|
voucher_number String? @db.VarChar(255)
|
|
entry_number String? @db.VarChar(255)
|
|
summary String? @db.VarChar(255)
|
|
account_code String? @db.VarChar(255)
|
|
account_name String? @db.VarChar(255)
|
|
auxiliary_items String? @db.VarChar(1000)
|
|
currency String? @db.VarChar(255)
|
|
debit_original_currency String? @db.VarChar(255)
|
|
debit_local_currency String? @db.VarChar(255)
|
|
credit_original_currency String? @db.VarChar(255)
|
|
credit_local_currency String? @db.VarChar(255)
|
|
shared_voucher_number String? @db.VarChar(255)
|
|
expense_budget_item String? @db.VarChar(255)
|
|
cost_center String? @db.VarChar(255)
|
|
standard_name String? @db.VarChar(255)
|
|
expense_type_level1 String? @db.VarChar(255)
|
|
expense_type_level2 String? @db.VarChar(255)
|
|
expense_type_level3 String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model procurement_contract_list {
|
|
data_id String @id @db.VarChar(255)
|
|
initiator String? @db.VarChar(255)
|
|
contract_number String? @db.VarChar(255)
|
|
contract_name String? @db.VarChar(255)
|
|
lvyue_faqi_bumen String? @db.VarChar(255)
|
|
operator String? @db.VarChar(255)
|
|
xiangduifang String? @db.VarChar(255)
|
|
is_open String? @db.VarChar(255)
|
|
contract_amount String? @db.VarChar(255)
|
|
remarks String? @db.VarChar(255)
|
|
performance_start_time String? @db.VarChar(255)
|
|
hetong_yuanjian_saomiaojian_gaizhangban String? @db.Text
|
|
dingtalk_procurement_approval_form String? @db.Text
|
|
contract_attachment_scan String? @db.Text
|
|
creation_time String? @db.VarChar(255)
|
|
creator String? @db.VarChar(255)
|
|
approval_result String? @db.VarChar(255)
|
|
approval_status String? @db.VarChar(255)
|
|
update_time String? @db.VarChar(255)
|
|
creator_department String? @db.VarChar(255)
|
|
approval_form_title String? @db.VarChar(255)
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model invoice_void_record {
|
|
logid Int @default(autoincrement())
|
|
dataId String @db.VarChar(255)
|
|
applicationDepartment String? @db.VarChar(255)
|
|
xiang_mu_zu_bie String? @db.VarChar(255)
|
|
applicationDate String? @db.VarChar(255)
|
|
applicant String? @db.VarChar(255)
|
|
piao_hao String? @db.VarChar(255)
|
|
kai_piao_ri_qi String? @db.VarChar(255)
|
|
agreementType String? @db.VarChar(255)
|
|
zuo_fei_shi_you String? @db.VarChar(255)
|
|
cancelReason String? @db.VarChar(255)
|
|
invoice_amount_yuan String? @db.VarChar(255)
|
|
is_tax_inclusive String? @db.VarChar(255)
|
|
feeBelongingTime String? @db.VarChar(255)
|
|
customerCompanyName String? @db.VarChar(255)
|
|
tong_yi_she_hui_xin_yong_dai_ma String? @db.VarChar(255)
|
|
bankName String? @db.VarChar(255)
|
|
bankAccount String? @db.VarChar(255)
|
|
uploadedVoidInvoiceAttachment String? @db.Text
|
|
handwrittenSignatureAttachment String? @db.Text
|
|
projectNumber String? @db.VarChar(255)
|
|
remark String? @db.VarChar(255)
|
|
|
|
@@id([logid, dataId])
|
|
}
|
|
|
|
/// This model or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
model customer_management_info {
|
|
data_id String @id @db.VarChar(255)
|
|
customer_unit_name String @db.VarChar(500)
|
|
customer_type String? @db.VarChar(100)
|
|
created_at DateTime? @default(now()) @db.Timestamp(0)
|
|
updated_at DateTime? @default(now()) @db.Timestamp(0)
|
|
}
|
|
|
|
/// This view or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
view invoice_application_match_inner_view {
|
|
dataId String @db.VarChar(255)
|
|
invoiceJobNumber Int @default(0)
|
|
agreementType String? @db.VarChar(255)
|
|
approvalNumber String? @db.VarChar(255)
|
|
salesContractNumber String? @db.VarChar(255)
|
|
applicationDepartment String? @db.VarChar(255)
|
|
yuJiBaoXiaoDiSanFangChengBenYuan String? @db.VarChar(255)
|
|
is_multi_project_merge String? @db.VarChar(255)
|
|
is_single_contract_multi_customer String? @db.VarChar(255)
|
|
projectNumber String? @db.VarChar(255)
|
|
customerCompanyName String? @db.VarChar(255)
|
|
customerCompanyNameOther String? @db.VarChar(255)
|
|
piao_hao String? @db.VarChar(50)
|
|
bu_han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_da String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
applicant String? @db.VarChar(255)
|
|
business_content_du String? @db.VarChar(255)
|
|
uploadedContractAttachment String? @db.Text
|
|
uploadedSealedCostListDa String? @db.Text
|
|
uploadedSealedCostListDu String? @db.Text
|
|
invoiceType String? @db.VarChar(50)
|
|
invoiceCode Int? @db.UnsignedTinyInt
|
|
kai_piao_shi_you String? @db.VarChar(255)
|
|
fa_piao_bei_zhu_lan_tian_xie_nei_rong String? @db.Text
|
|
tong_yi_she_hui_xin_yong_dai_ma String? @db.VarChar(255)
|
|
bankName String? @db.VarChar(255)
|
|
bankAccount String? @db.VarChar(255)
|
|
invoice_type_enum Int?
|
|
kai_piao_ri_qi String? @db.VarChar(50)
|
|
hui_kuan_ri_qi String? @db.VarChar(255)
|
|
hui_kuan_jin_e String? @db.VarChar(255)
|
|
zhang_qi String? @db.VarChar(255)
|
|
unit_nature String? @db.VarChar(100)
|
|
hong_chong_piao_hao String? @db.VarChar(50)
|
|
}
|
|
|
|
/// This view or at least one of its fields has comments in the database, and requires an additional setup for migrations: Read more: https://pris.ly/d/database-comments
|
|
view invoice_application_match_view {
|
|
dataId String @db.VarChar(255)
|
|
invoiceJobNumber Int @default(0)
|
|
agreementType String? @db.VarChar(255)
|
|
approvalNumber String? @db.VarChar(255)
|
|
salesContractNumber String? @db.VarChar(255)
|
|
applicationDepartment String? @db.VarChar(255)
|
|
yuJiBaoXiaoDiSanFangChengBenYuan String? @db.VarChar(255)
|
|
is_multi_project_merge String? @db.VarChar(255)
|
|
is_single_contract_multi_customer String? @db.VarChar(255)
|
|
projectNumber String? @db.VarChar(255)
|
|
customerCompanyName String? @db.VarChar(255)
|
|
customerCompanyNameOther String? @db.VarChar(255)
|
|
piao_hao String? @db.VarChar(50)
|
|
bu_han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_da String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_da_du String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_duo String? @db.VarChar(255)
|
|
bu_han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
han_shui_jin_e_yuan_other String? @db.VarChar(255)
|
|
applicant String? @db.VarChar(255)
|
|
business_content_du String? @db.VarChar(255)
|
|
uploadedContractAttachment String? @db.Text
|
|
uploadedSealedCostListDa String? @db.Text
|
|
uploadedSealedCostListDu String? @db.Text
|
|
invoiceType String? @db.VarChar(50)
|
|
invoiceCode Int? @db.UnsignedTinyInt
|
|
kai_piao_shi_you String? @db.VarChar(255)
|
|
fa_piao_bei_zhu_lan_tian_xie_nei_rong String? @db.Text
|
|
tong_yi_she_hui_xin_yong_dai_ma String? @db.VarChar(255)
|
|
bankName String? @db.VarChar(255)
|
|
bankAccount String? @db.VarChar(255)
|
|
invoice_type_enum Int?
|
|
kai_piao_ri_qi String? @db.VarChar(50)
|
|
hui_kuan_ri_qi String? @db.VarChar(255)
|
|
hui_kuan_jin_e String? @db.VarChar(255)
|
|
zhang_qi String? @db.VarChar(255)
|
|
unit_nature String? @db.VarChar(100)
|
|
hong_chong_piao_hao String? @db.VarChar(50)
|
|
}
|