dbschema 0.1.4

Define database schema's as HCL files, and generate idempotent SQL migrations
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35

# Domain

Defines a custom domain built on top of a base type with optional constraints.

```hcl
domain "email" {
  type = "text"
  check = "VALUE ~* '^[^@]+@[^@]+$'"
}
```

## Attributes
- `name` (label): domain name.
- `schema` (string, optional): schema for the domain. Defaults to `public`.
- `type` (string): underlying data type.
- `not_null` (bool, optional): add `NOT NULL` constraint.
- `default` (string, optional): default value expression.
- `constraint` (string, optional): name of a constraint.
- `check` (string, optional): `CHECK` expression using `VALUE`.
- `comment` (string, optional): documentation comment.

## Examples

```hcl
domain "email" {
  type = "text"
  not_null = true
  check = "VALUE ~ '^[^@]+@[^@]+\.[^@]+$'"
}

domain "nonempty_text" {
  type = "text"
  check = "VALUE <> ''"
}
```