dbschema 0.1.2

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
36
37
38
39
40
41

# Sequence

Defines an auto-incrementing sequence.

```hcl
sequence "user_id_seq" {
  schema    = "public"
  as        = "bigint"
  increment = 1
  min_value = 1
  start     = 1
  cache     = 1
  cycle     = false
  owned_by  = "users.id"
}
```

## Attributes
- `name` (label): sequence name.
- `schema` (string, optional): schema for the sequence. Defaults to `public`.
- `if_not_exists` (bool, optional): emit `IF NOT EXISTS`.
- `as` (string, optional): data type of the sequence.
- `increment`, `min_value`, `max_value`, `start`, `cache` (numbers, optional): control sequence behavior.
- `cycle` (bool, optional): wrap around when reaching limits.
- `owned_by` (string, optional): table column this sequence is owned by.
- `comment` (string, optional): documentation comment.

## Examples

```hcl
sequence "order_id_seq" {
  as = "bigint"
  start = 1000
  increment = 1
}

table "orders" {
  column "id" { type = "bigint", nullable = false, default = "nextval('order_id_seq')" }
  primary_key { columns = ["id"] }
}
```