53 lines
2.2 KiB
Plaintext
53 lines
2.2 KiB
Plaintext
generator client {
|
|
provider = "prisma-client-js"
|
|
}
|
|
|
|
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 ReserveCustomer {
|
|
autonum Int @id @default(autoincrement())
|
|
reserve_num Int
|
|
reserve_time String @db.VarChar(8)
|
|
cust_name String @db.VarChar(255)
|
|
cust_email String @default("none") @db.VarChar(255)
|
|
cust_parent Int @default(0)
|
|
cust_child Int @default(0)
|
|
fix_parent Int @default(0)
|
|
fix_child Int @default(0)
|
|
fix_money Int @default(0)
|
|
fix_all Int @default(0) @db.TinyInt
|
|
cancel_flag Int @default(0)
|
|
reserve_datetime DateTime @default(dbgenerated("CURRENT_TIMESTAMP")) @db.DateTime(0)
|
|
reserve_result String? @db.VarChar(255)
|
|
thanks_token String? @db.VarChar(255)
|
|
setting ReserveSetting @relation("SettingToCustomers", fields: [reserve_num], references: [autonum])
|
|
@@map("reserve_customer")
|
|
}
|
|
|
|
/// 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 ReserveSetting {
|
|
autonum Int @id @default(autoincrement())
|
|
diner_date DateTime @db.Date
|
|
reserve_startdate DateTime @db.DateTime(0)
|
|
reserve_limitdate DateTime @db.DateTime(0)
|
|
start_time String @db.VarChar(8)
|
|
end_time String @db.VarChar(8)
|
|
time_range Int @db.TinyInt
|
|
reserve_limit Int @default(0)
|
|
limit_method String @default("block") @db.VarChar(5)
|
|
limit_type String @default("set") @db.VarChar(10)
|
|
menu String? @db.VarChar(255)
|
|
parent_money Int @default(0)
|
|
child_money Int @default(0)
|
|
note String? @db.Text
|
|
delete_flag Int @default(0) @db.TinyInt
|
|
createdatetime DateTime @default(now()) @db.Timestamp(0)
|
|
lastupdate DateTime @default(now()) @db.Timestamp(0)
|
|
customers ReserveCustomer[] @relation("SettingToCustomers")
|
|
@@map("reserve_setting")
|
|
}
|