Skip to content

Instantly share code, notes, and snippets.

tables: # In this section, we define the tables, their name and schema
userinfo: # This is the table name
columns: # In this section, we define column names and their data types
- name: id
type: integer
primary_key: true # Set this value for the primary key column
tables:
userinfo:
columns:
- name: id
type: integer
primary_key: true
- name: firstname
type: varchar
tables:
user:
columns:
- name: user_id
type: integer
primary_key: true
- name: firstname
type: varchar
length: 20
tables:
user:
columns:
- name: user_id
type: integer
primary_key: true
- name: firstname
type: varchar
length: 20