Current section
Files
Jump to
Current section
Files
test/data/table.dbml
// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs
Table property {
unit_id integer [primary key, ref: > unit.unit_id]
property_id integer [pk]
name varchar [not null]
url varchar
created_at timestamp [not null]
updated_at timestamp
indexes {
name [unique, name: "idx_property_name"]
}
Note: '''
Defines a unit of measure,
which is a multi-line string
'''
}
Table user1 [] {
f1 string
}
Table user2 [note: 'User table'] {
f1 string
}
Table user3 [note: 'User table', color: #123aaa] {
f1 string
}