45 lines
668 B
HCL
45 lines
668 B
HCL
table "users" {
|
|
schema = schema.public
|
|
|
|
column "id" {
|
|
type = uuid
|
|
null = false
|
|
}
|
|
column "first_name" {
|
|
type = text
|
|
}
|
|
column "last_name" {
|
|
type = text
|
|
}
|
|
column "display_name" {
|
|
type = text
|
|
}
|
|
column "email" {
|
|
type = text
|
|
null = false
|
|
}
|
|
|
|
column "created_at" {
|
|
type = timestamptz
|
|
default = sql("now()")
|
|
null = false
|
|
}
|
|
|
|
column "updated_at" {
|
|
type = timestamptz
|
|
null = true
|
|
default = sql("now()")
|
|
}
|
|
column "deleted_at" {
|
|
type = timestamptz
|
|
null = true
|
|
}
|
|
|
|
primary_key {
|
|
columns = [column.id]
|
|
}
|
|
|
|
unique "users_email_unique" {
|
|
columns = [column.email]
|
|
}
|
|
} |