85 lines
3.0 KiB
Plaintext
85 lines
3.0 KiB
Plaintext
model tele_carte {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
delivery_id Int @unique(map: "delivery_id") @default(0) @db.UnsignedInt
|
|
service_id Int @db.UnsignedInt
|
|
channels String @db.Text
|
|
}
|
|
|
|
model tele_channel {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
proprio String @db.VarChar(128)
|
|
poste String @db.VarChar(128)
|
|
pack_min Int @default(0) @db.UnsignedTinyInt
|
|
pack_redevance Decimal @default(0.00) @db.Decimal(5, 2)
|
|
pack_prix_vendu Decimal @default(0.00) @db.Decimal(5, 2)
|
|
carte_percentage Decimal @db.Decimal(5, 2)
|
|
carte_redevance_min Decimal @db.Decimal(5, 2)
|
|
carte_prix_vendu Decimal @db.Decimal(5, 2)
|
|
monthly_min Decimal @default(0.00) @db.Decimal(5, 2)
|
|
has_penetration_rate Int @default(0) @db.UnsignedTinyInt
|
|
penetration_actuel Decimal @default(0.00) @db.Decimal(3, 2)
|
|
is_commercial Int @default(0) @db.UnsignedTinyInt
|
|
note String @db.Text
|
|
epgId Int @default(0) @db.UnsignedInt
|
|
uptele_no Int @db.UnsignedInt
|
|
uptele_code String @db.VarChar(32)
|
|
abbr String @db.VarChar(32)
|
|
groupe_id Int @default(0) @db.UnsignedInt
|
|
ccsa_packageID Int @db.UnsignedInt
|
|
ccsa_desc String @db.VarChar(256)
|
|
rapport_bell Int @default(0) @db.TinyInt
|
|
}
|
|
|
|
model tele_groupe {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
nom String @db.VarChar(128)
|
|
small_desc String @db.VarChar(128)
|
|
}
|
|
|
|
model tele_network {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
network_name String @db.VarChar(128)
|
|
fournisseur String @db.VarChar(128)
|
|
}
|
|
|
|
model tele_pack {
|
|
id Int @id @default(autoincrement())
|
|
product_id Int @db.UnsignedInt
|
|
channels String @db.Text
|
|
actif Boolean @default(true)
|
|
ccsa_packageID Int @db.UnsignedInt
|
|
ccsa_desc String @db.VarChar(256)
|
|
rapport_bell Int @default(0) @db.TinyInt
|
|
bell_name String? @db.VarChar(64)
|
|
epgId Int? @db.UnsignedInt
|
|
}
|
|
|
|
model tele_penetration {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
id_channel Int @db.UnsignedInt
|
|
percentage Decimal @db.Decimal(3, 2)
|
|
prix Decimal @db.Decimal(10, 5)
|
|
}
|
|
|
|
model tele_sub_archive {
|
|
id Int @id @default(autoincrement())
|
|
date_archive String @db.VarChar(16)
|
|
subs String @db.Text
|
|
}
|
|
|
|
model tele_wiz {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
account_id Int @db.UnsignedInt
|
|
delivery_id Int @db.UnsignedInt
|
|
ticket_id Int @db.UnsignedInt
|
|
nb_stb Int @db.UnsignedTinyInt
|
|
credit Int @db.UnsignedTinyInt
|
|
fbase Int @db.UnsignedInt
|
|
fthem String @db.Text
|
|
}
|
|
|
|
model tv_mac {
|
|
id Int @id @default(autoincrement()) @db.UnsignedInt
|
|
service_id Int @db.UnsignedInt
|
|
mac String @db.VarChar(12)
|
|
} |