720 lines
23 KiB
Plaintext
720 lines
23 KiB
Plaintext
generator client {
|
||
provider = "prisma-client-js"
|
||
binaryTargets = ["windows"]
|
||
}
|
||
|
||
datasource db {
|
||
provider = "mysql"
|
||
url = env("DATABASE_URL")
|
||
}
|
||
|
||
// 管理员账号
|
||
model Admin {
|
||
id String @id // 账号ID A(RRRRRR)
|
||
name String @unique // 账号名
|
||
password String // 密码
|
||
username String // 用户名
|
||
type Int @default(1) // 账号类型 1 - 超级管理员, 2 - 管理员
|
||
status Int @default(1) // 账号状态 0 - 禁用, 1 - 可用
|
||
authz_hist_mgmt Int @default(1) // 历史管理
|
||
authz_tmpl_mgmt Int @default(1) // 模板管理
|
||
authz_mtrl_mgmt Int @default(1) // 材料管理
|
||
authz_audit_mgmt Int @default(1) // 审核管理
|
||
authz_acct_mgmt Int @default(1) // 账号管理
|
||
authz_sys_cfg Int @default(1) // 系统设置
|
||
templates PublicTemplate[]
|
||
materials PublicMaterial[]
|
||
applied_requests AuditRequest[] @relation("applied_requests")
|
||
reviewed_requests AuditRequest[] @relation("reviewed_requests")
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
deleted Int @default(0)
|
||
|
||
@@map("admin")
|
||
}
|
||
|
||
// 用户账号
|
||
model User {
|
||
id String @id // 账号ID U(RRRRRR)
|
||
name String @unique // 账户名
|
||
password String // 密码
|
||
username String // 用户名
|
||
status Int @default(1) // 账号状态 0 - 禁用, 1 - 可用
|
||
projects Project[]
|
||
templates SelfTemplate[]
|
||
materials SelfMaterial[]
|
||
pub_temp_colls PublicTemplateCollection[] // 收藏的公共模板
|
||
pub_mtrl_colls PublicMaterialCollection[] // 收藏的公共材料
|
||
pub_templates PublicTemplate[]
|
||
pub_materials PublicMaterial[]
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
deleted Int @default(0)
|
||
phone String? @unique // 手机号（手机注册用户）
|
||
|
||
@@map("user")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 项目
|
||
model Project {
|
||
id String @id // 项目ID P(yMdHmSRR)
|
||
name String? // 项目名称
|
||
category String? // 项目类型
|
||
province String? // 所在省份
|
||
city String? // 所在城市
|
||
climatic_zone String? // 所在气候区
|
||
constr_area Float? // 建筑面积
|
||
usage_area Float? // 使用面积
|
||
spaces Space[] // 包含空间
|
||
status Int @default(0) // 状态 0 - 未生成预测报告, 1 - 已生成预测报告
|
||
predicted_at DateTime? // 预测报告生成时间
|
||
score Float? // 得分
|
||
grade String? // 评级
|
||
creator_id String?
|
||
creator_name String
|
||
creator User? @relation(fields: [creator_id], references: [id], onDelete: SetNull)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("project")
|
||
}
|
||
|
||
// 项目空间
|
||
model Space {
|
||
id String @id // 空间ID S(yMdHmSRR)
|
||
project_id String // 所属项目ID
|
||
project Project @relation(fields: [project_id], references: [id], onDelete: Cascade) // 所属项目
|
||
name String? // 空间名称
|
||
category String? // 空间类型
|
||
layout Int? // 空间布局
|
||
height Float? // 空间高度
|
||
area Float? // 空间面积
|
||
volume Float? // 空间体积
|
||
env_temp Float? // 环境温度
|
||
env_hum Float? // 环境湿度
|
||
env_vent_rate Float? // 环境通风换气率
|
||
apc_lmt_std_id String? // 空气污染物浓度限值标准ID
|
||
apc_lmt_std ApcLimitStandard? @relation(fields: [apc_lmt_std_id], references: [id], onDelete: SetNull) // 空气污染物浓度限值标准
|
||
materials Material[] // 包含材料
|
||
methanal_c Float? // 甲醛浓度
|
||
tvoc_c Float? // TVOC浓度
|
||
benzene_c Float? // 苯浓度
|
||
toluene_c Float? // 甲苯浓度
|
||
p_xylene_c Float? // 二甲苯浓度
|
||
methanal_c_exceed Int? // 甲醛是否超标
|
||
tvoc_c_exceed Int? // TVOC是否超标
|
||
benzene_c_exceed Int? // 苯是否超标
|
||
toluene_c_exceed Int? // 甲苯是否超标
|
||
p_xylene_c_exceed Int? // 二甲苯是否超标
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("space")
|
||
}
|
||
|
||
// 空间材料
|
||
model Material {
|
||
id Int @id @default(autoincrement()) // 材料ID
|
||
material_id String // 所属材料ID
|
||
project_id String // 所属项目ID
|
||
space_id String // 所属空间ID
|
||
space Space @relation(fields: [space_id], references: [id], onDelete: Cascade) // 所属空间
|
||
name String? // 材料名称
|
||
category String? // 材料类型
|
||
brand String? // 材料品牌
|
||
factory String? // 材料厂家
|
||
spec String? // 材料规格
|
||
eco_level String? // 环保等级
|
||
unit String? // 用量单位 AREA - 面积, LEN - 长度
|
||
qty Float? // 用量值
|
||
methanal Float? // 甲醛
|
||
methanal_min_be Float? // 甲醛最低平衡释放量
|
||
methanal_be_area Float? // 甲醛平衡释放量范围
|
||
methanal_be_roc Float? // 甲醛平衡释放量变化率
|
||
tvoc Float? // TVOC
|
||
tvoc_min_be Float? // TVOC最低平衡释放量
|
||
tvoc_be_area Float? // TVOC平衡释放量范围
|
||
tvoc_be_roc Float? // TVOC平衡释放量变化率
|
||
benzene Float? // 苯
|
||
benzene_min_be Float? // 苯最低平衡释放量
|
||
benzene_be_area Float? // 苯平衡释放量范围
|
||
benzene_be_roc Float? // 苯平衡释放量变化率
|
||
toluene Float? // 甲苯
|
||
toluene_min_be Float? // 甲苯最低平衡释放量
|
||
toluene_be_area Float? // 甲苯平衡释放量范围
|
||
toluene_be_roc Float? // 甲苯平衡释放量变化率
|
||
p_xylene Float? // 二甲苯
|
||
p_xylene_min_be Float? // 二甲苯最低平衡释放量
|
||
p_xylene_be_area Float? // 二甲苯平衡释放量范围
|
||
p_xylene_be_roc Float? // 二甲苯平衡释放量变化率
|
||
methanal_cr Float? // 甲醛贡献率
|
||
tvoc_cr Float? // TVOC贡献率
|
||
benzene_cr Float? // 苯贡献率
|
||
toluene_cr Float? // 甲苯贡献率
|
||
p_xylene_cr Float? // 二甲苯贡献率
|
||
methanal_cr_exceed Int? // 甲醛贡献率是否超标
|
||
tvoc_cr_exceed Int? // TVOC贡献率是否超标
|
||
benzene_cr_exceed Int? // 苯贡献率是否超标
|
||
toluene_cr_exceed Int? // 甲苯贡献率是否超标
|
||
p_xylene_cr_exceed Int? // 二甲苯贡献率是否超标
|
||
is_methanal_ps Int? // 是否为甲醛污染源
|
||
is_tvoc_ps Int? // 是否为TVOC污染源
|
||
is_benzene_ps Int? // 是否为苯污染源
|
||
is_toluene_ps Int? // 是否为甲苯污染源
|
||
is_p_xylene_ps Int? // 是否为二甲苯污染源
|
||
user_id String
|
||
user_name String
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("material")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 公共项目模板
|
||
model PublicTemplate {
|
||
id String @id // PT(yMdHmSRR)
|
||
name String?
|
||
category String?
|
||
province String?
|
||
city String?
|
||
climatic_zone String?
|
||
constr_area Float?
|
||
usage_area Float?
|
||
spaces PublicTemplateSpace[]
|
||
display Int @default(0) // 是否展示
|
||
collectors PublicTemplateCollection[] // 收藏此模板的用户
|
||
pry_no Int @default(0)
|
||
score Float?
|
||
grade String?
|
||
from String?
|
||
creator_id String
|
||
creator_name String
|
||
related_user_id String?
|
||
related_user User? @relation(fields: [related_user_id], references: [id], onDelete: SetNull)
|
||
related_admin_id String?
|
||
related_admin Admin? @relation(fields: [related_admin_id], references: [id], onDelete: SetNull)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("public_template")
|
||
}
|
||
|
||
// 公共项目模板空间
|
||
model PublicTemplateSpace {
|
||
id String @id // PTS(yMdHmSRR)
|
||
project_id String
|
||
project PublicTemplate @relation(fields: [project_id], references: [id], onDelete: Cascade)
|
||
name String?
|
||
category String?
|
||
layout Int?
|
||
height Float?
|
||
area Float?
|
||
volume Float?
|
||
env_temp Float?
|
||
env_hum Float?
|
||
env_vent_rate Float?
|
||
apc_lmt_std_id String?
|
||
apc_lmt_std ApcLimitStandard? @relation(fields: [apc_lmt_std_id], references: [id], onDelete: SetNull)
|
||
materials PublicTemplateMaterial[]
|
||
methanal_c Float?
|
||
tvoc_c Float?
|
||
benzene_c Float?
|
||
toluene_c Float?
|
||
p_xylene_c Float?
|
||
methanal_c_exceed Int?
|
||
tvoc_c_exceed Int?
|
||
benzene_c_exceed Int?
|
||
toluene_c_exceed Int?
|
||
p_xylene_c_exceed Int?
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("public_template_space")
|
||
}
|
||
|
||
// 公共项目模板材料
|
||
model PublicTemplateMaterial {
|
||
id Int @id @default(autoincrement())
|
||
material_id String
|
||
project_id String
|
||
space_id String
|
||
space PublicTemplateSpace @relation(fields: [space_id], references: [id], onDelete: Cascade)
|
||
name String?
|
||
category String?
|
||
brand String?
|
||
factory String?
|
||
spec String?
|
||
eco_level String?
|
||
unit String?
|
||
qty Float?
|
||
methanal Float?
|
||
methanal_min_be Float?
|
||
methanal_be_area Float?
|
||
methanal_be_roc Float?
|
||
tvoc Float?
|
||
tvoc_min_be Float?
|
||
tvoc_be_area Float?
|
||
tvoc_be_roc Float?
|
||
benzene Float?
|
||
benzene_min_be Float?
|
||
benzene_be_area Float?
|
||
benzene_be_roc Float?
|
||
toluene Float?
|
||
toluene_min_be Float?
|
||
toluene_be_area Float?
|
||
toluene_be_roc Float?
|
||
p_xylene Float?
|
||
p_xylene_min_be Float?
|
||
p_xylene_be_area Float?
|
||
p_xylene_be_roc Float?
|
||
methanal_cr Float?
|
||
tvoc_cr Float?
|
||
benzene_cr Float?
|
||
toluene_cr Float?
|
||
p_xylene_cr Float?
|
||
methanal_cr_exceed Int?
|
||
tvoc_cr_exceed Int?
|
||
benzene_cr_exceed Int?
|
||
toluene_cr_exceed Int?
|
||
p_xylene_cr_exceed Int?
|
||
is_methanal_ps Int?
|
||
is_tvoc_ps Int?
|
||
is_benzene_ps Int?
|
||
is_toluene_ps Int?
|
||
is_p_xylene_ps Int?
|
||
user_id String
|
||
user_name String
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("public_template_material")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 自建模板
|
||
model SelfTemplate {
|
||
id String // ST(yMdHmSRR)
|
||
name String?
|
||
category String?
|
||
province String?
|
||
city String?
|
||
climatic_zone String?
|
||
constr_area Float?
|
||
usage_area Float?
|
||
spaces SelfTemplateSpace[]
|
||
score Float?
|
||
grade String?
|
||
creator_id String
|
||
creator_name String
|
||
creator User @relation(fields: [creator_id], references: [id], onDelete: Cascade)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@id([id, creator_id])
|
||
@@map("self_template")
|
||
}
|
||
|
||
// 自建模板空间
|
||
model SelfTemplateSpace {
|
||
id String // STS(yMdHmSRR)
|
||
project_id String
|
||
project SelfTemplate @relation(fields: [project_id, creator_id], references: [id, creator_id], onDelete: Cascade)
|
||
name String?
|
||
category String?
|
||
layout Int?
|
||
height Float?
|
||
area Float?
|
||
volume Float?
|
||
env_temp Float?
|
||
env_hum Float?
|
||
env_vent_rate Float?
|
||
apc_lmt_std_id String?
|
||
apc_lmt_std ApcLimitStandard? @relation(fields: [apc_lmt_std_id], references: [id], onDelete: SetNull)
|
||
materials SelfTemplateMaterial[]
|
||
methanal_c Float?
|
||
tvoc_c Float?
|
||
benzene_c Float?
|
||
toluene_c Float?
|
||
p_xylene_c Float?
|
||
methanal_c_exceed Int?
|
||
tvoc_c_exceed Int?
|
||
benzene_c_exceed Int?
|
||
toluene_c_exceed Int?
|
||
p_xylene_c_exceed Int?
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@id([id, project_id])
|
||
@@map("self_template_space")
|
||
}
|
||
|
||
// 自建项目模板材料
|
||
model SelfTemplateMaterial {
|
||
id Int @id @default(autoincrement())
|
||
material_id String
|
||
project_id String
|
||
space_id String
|
||
space SelfTemplateSpace @relation(fields: [space_id, project_id], references: [id, project_id], onDelete: Cascade)
|
||
name String?
|
||
category String?
|
||
brand String?
|
||
factory String?
|
||
spec String?
|
||
eco_level String?
|
||
unit String?
|
||
qty Float?
|
||
methanal Float?
|
||
methanal_min_be Float?
|
||
methanal_be_area Float?
|
||
methanal_be_roc Float?
|
||
tvoc Float?
|
||
tvoc_min_be Float?
|
||
tvoc_be_area Float?
|
||
tvoc_be_roc Float?
|
||
benzene Float?
|
||
benzene_min_be Float?
|
||
benzene_be_area Float?
|
||
benzene_be_roc Float?
|
||
toluene Float?
|
||
toluene_min_be Float?
|
||
toluene_be_area Float?
|
||
toluene_be_roc Float?
|
||
p_xylene Float?
|
||
p_xylene_min_be Float?
|
||
p_xylene_be_area Float?
|
||
p_xylene_be_roc Float?
|
||
methanal_cr Float?
|
||
tvoc_cr Float?
|
||
benzene_cr Float?
|
||
toluene_cr Float?
|
||
p_xylene_cr Float?
|
||
methanal_cr_exceed Int?
|
||
tvoc_cr_exceed Int?
|
||
benzene_cr_exceed Int?
|
||
toluene_cr_exceed Int?
|
||
p_xylene_cr_exceed Int?
|
||
is_methanal_ps Int?
|
||
is_tvoc_ps Int?
|
||
is_benzene_ps Int?
|
||
is_toluene_ps Int?
|
||
is_p_xylene_ps Int?
|
||
user_id String
|
||
user_name String
|
||
creator_id String
|
||
creator_name String
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("self_template_material")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 公共材料
|
||
model PublicMaterial {
|
||
material_id String @id // PM(yMdHmSRR)
|
||
name String?
|
||
category String?
|
||
brand String?
|
||
factory String?
|
||
spec String?
|
||
eco_level String?
|
||
health_level String?
|
||
model_name String?
|
||
sample_image String?
|
||
reference_price String?
|
||
application_case String?
|
||
effect_image String?
|
||
supplier String?
|
||
contact_person String?
|
||
contact_phone String?
|
||
production_date String?
|
||
batch_no String?
|
||
sample_source String?
|
||
client_unit String?
|
||
test_date String?
|
||
test_standard String?
|
||
report_no String?
|
||
test_org String?
|
||
methanal Float?
|
||
methanal_min_be Float?
|
||
methanal_be_area Float?
|
||
methanal_be_roc Float?
|
||
tvoc Float?
|
||
tvoc_min_be Float?
|
||
tvoc_be_area Float?
|
||
tvoc_be_roc Float?
|
||
benzene Float?
|
||
benzene_min_be Float?
|
||
benzene_be_area Float?
|
||
benzene_be_roc Float?
|
||
toluene Float?
|
||
toluene_min_be Float?
|
||
toluene_be_area Float?
|
||
toluene_be_roc Float?
|
||
p_xylene Float?
|
||
p_xylene_min_be Float?
|
||
p_xylene_be_area Float?
|
||
p_xylene_be_roc Float?
|
||
sort_order Int @default(0) // 手动排序权重，升序
|
||
display Int @default(0) // 是否展示
|
||
collectors PublicMaterialCollection[] // 收藏此材料的用户
|
||
pry_no Int @default(0)
|
||
from String?
|
||
creator_id String
|
||
creator_name String
|
||
related_user_id String?
|
||
related_user User? @relation(fields: [related_user_id], references: [id], onDelete: SetNull)
|
||
related_admin_id String?
|
||
related_admin Admin? @relation(fields: [related_admin_id], references: [id], onDelete: SetNull)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("public_material")
|
||
}
|
||
|
||
// 自建材料
|
||
model SelfMaterial {
|
||
material_id String // SM(yMdHmSRR)
|
||
name String?
|
||
category String?
|
||
brand String?
|
||
factory String?
|
||
spec String?
|
||
eco_level String?
|
||
health_level String?
|
||
model_name String?
|
||
sample_image String?
|
||
reference_price String?
|
||
application_case String?
|
||
effect_image String?
|
||
supplier String?
|
||
contact_person String?
|
||
contact_phone String?
|
||
production_date String?
|
||
batch_no String?
|
||
sample_source String?
|
||
client_unit String?
|
||
test_date String?
|
||
test_standard String?
|
||
report_no String?
|
||
test_org String?
|
||
methanal Float?
|
||
methanal_min_be Float?
|
||
methanal_be_area Float?
|
||
methanal_be_roc Float?
|
||
tvoc Float?
|
||
tvoc_min_be Float?
|
||
tvoc_be_area Float?
|
||
tvoc_be_roc Float?
|
||
benzene Float?
|
||
benzene_min_be Float?
|
||
benzene_be_area Float?
|
||
benzene_be_roc Float?
|
||
toluene Float?
|
||
toluene_min_be Float?
|
||
toluene_be_area Float?
|
||
toluene_be_roc Float?
|
||
p_xylene Float?
|
||
p_xylene_min_be Float?
|
||
p_xylene_be_area Float?
|
||
p_xylene_be_roc Float?
|
||
sort_order Int @default(0)
|
||
creator_id String
|
||
creator_name String
|
||
creator User @relation(fields: [creator_id], references: [id], onDelete: Cascade)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@id([material_id, creator_id])
|
||
@@map("self_material")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 用户收藏的公共模板
|
||
model PublicTemplateCollection {
|
||
user_id String
|
||
user User @relation(fields: [user_id], references: [id], onDelete: Cascade)
|
||
project_id String
|
||
project PublicTemplate @relation(fields: [project_id], references: [id], onDelete: Cascade)
|
||
|
||
@@id([user_id, project_id])
|
||
@@map("public_template_collection")
|
||
}
|
||
|
||
// 用户收藏的公共材料
|
||
model PublicMaterialCollection {
|
||
user_id String
|
||
user User @relation(fields: [user_id], references: [id], onDelete: Cascade)
|
||
material_id String
|
||
material PublicMaterial @relation(fields: [material_id], references: [material_id], onDelete: Cascade)
|
||
|
||
@@id([user_id, material_id])
|
||
@@map("public_material_collection")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 审核单
|
||
model AuditRequest {
|
||
id String @id
|
||
status Int @default(0)
|
||
source_id String?
|
||
source_creator_id String?
|
||
source String
|
||
type String
|
||
desc String?
|
||
remark String?
|
||
reason String?
|
||
details AuditRequestDetails[]
|
||
auditor_id String?
|
||
auditor_name String?
|
||
auditor Admin? @relation(name: "reviewed_requests", fields: [auditor_id], references: [id], onDelete: SetNull)
|
||
audited_at DateTime?
|
||
creator_id String?
|
||
creator_name String
|
||
creator Admin? @relation(name: "applied_requests", fields: [creator_id], references: [id], onDelete: SetNull)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("audit_request")
|
||
}
|
||
|
||
// 审核单详情
|
||
model AuditRequestDetails {
|
||
id Int @id @default(autoincrement())
|
||
aduit_request_id String
|
||
audit_request AuditRequest @relation(fields: [aduit_request_id], references: [id], onDelete: Cascade)
|
||
content Json
|
||
|
||
@@map("audit_request_details")
|
||
}
|
||
|
||
// ------
|
||
|
||
// 项目-空间类型
|
||
model ProjectSpaceCategory {
|
||
pry_no_1 Int @default(0)
|
||
pry_no_2 Int @default(0)
|
||
project_category String
|
||
space_category String
|
||
|
||
@@id([project_category, space_category])
|
||
@@map("project_space_category")
|
||
}
|
||
|
||
// 材料类型
|
||
model MaterialCategory {
|
||
pry_no_1 Int @default(0)
|
||
pry_no_2 Int @default(0)
|
||
first_category String
|
||
second_category String
|
||
unit String?
|
||
|
||
@@id([first_category, second_category])
|
||
@@map("material_category")
|
||
}
|
||
|
||
// 省-市-气候区-温度-湿度
|
||
model CityInformation {
|
||
pry_no_1 Int @default(0)
|
||
pry_no_2 Int @default(0)
|
||
province String
|
||
city String
|
||
climatic_zone String?
|
||
env_temp Float
|
||
env_hum Float
|
||
|
||
@@id([province, city])
|
||
@@map("city_information")
|
||
}
|
||
|
||
// 空气污染物浓度限值标准
|
||
model ApcLimitStandard {
|
||
id String @id // 标准ID
|
||
methanal_c_lmt Float // 甲醛浓度限值
|
||
tvoc_c_lmt Float // TVOC浓度限值
|
||
benzene_c_lmt Float // 苯浓度限值
|
||
toluene_c_lmt Float // 甲苯浓度限值
|
||
p_xylene_c_lmt Float // 二甲苯浓度限值
|
||
spaces Space[] // 使用该模板的项目空间
|
||
pub_temp_spaces PublicTemplateSpace[] // 使用该标准的公共模板空间
|
||
self_temp_spaces SelfTemplateSpace[] // 使用该标准的自建模板空间
|
||
|
||
@@map("apc_limit_standard")
|
||
}
|
||
|
||
// ------ 论坛 ------
|
||
|
||
model SiteConfig {
|
||
key String @id
|
||
value String @db.Text
|
||
updated_at DateTime @updatedAt
|
||
|
||
@@map("site_config")
|
||
}
|
||
|
||
// ------ 论坛 ------
|
||
|
||
model ForumThread {
|
||
id Int @id @default(autoincrement())
|
||
board String // 板块（取值属于 FORUM_BOARDS）
|
||
title String
|
||
content String @db.Text
|
||
author_id String // User.id
|
||
author_name String // 冗余 username
|
||
like_count Int @default(0)
|
||
reply_count Int @default(0)
|
||
created_at DateTime @default(now())
|
||
updated_at DateTime @updatedAt
|
||
deleted Int @default(0)
|
||
replies ForumReply[]
|
||
likes ForumThreadLike[]
|
||
|
||
@@map("forum_thread")
|
||
}
|
||
|
||
model ForumReply {
|
||
id Int @id @default(autoincrement())
|
||
thread_id Int
|
||
thread ForumThread @relation(fields: [thread_id], references: [id], onDelete: Cascade)
|
||
floor Int // 楼层
|
||
content String @db.Text
|
||
author_id String
|
||
author_name String
|
||
created_at DateTime @default(now())
|
||
deleted Int @default(0)
|
||
|
||
@@map("forum_reply")
|
||
}
|
||
|
||
model ForumThreadLike {
|
||
thread_id Int
|
||
thread ForumThread @relation(fields: [thread_id], references: [id], onDelete: Cascade)
|
||
user_id String
|
||
created_at DateTime @default(now())
|
||
|
||
@@id([thread_id, user_id])
|
||
@@map("forum_thread_like")
|
||
}
|