39 lines
655 B
HCL
39 lines
655 B
HCL
table "death_notices" {
|
|
schema = schema.pomos
|
|
column "id" {
|
|
null = false
|
|
type = serial
|
|
}
|
|
column "dn_death" {
|
|
null = true
|
|
type = date
|
|
}
|
|
column "dn_name" {
|
|
null = true
|
|
type = character_varying
|
|
}
|
|
column "dn_location" {
|
|
null = true
|
|
type = character_varying
|
|
}
|
|
column "dn_picture" {
|
|
null = true
|
|
type = bytea
|
|
}
|
|
column "dn_age" {
|
|
null = true
|
|
type = smallint
|
|
}
|
|
primary_key {
|
|
columns = [column.id]
|
|
}
|
|
unique "unique_death_notice" {
|
|
columns = [column.dn_death, column.dn_name, column.dn_location]
|
|
}
|
|
}
|
|
schema "pomos" {
|
|
}
|
|
schema "public" {
|
|
comment = "standard public schema"
|
|
}
|