example.yaml

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

      - name: firstname # Column name
        type: varchar # Column datatype
        length: 20

      - name: lastname
        type: varchar
        length: 20

      - name: dob
        type: date

      - name: contact
        type: numeric
        nullable: false # Allow / disallow null values in the column, default `true`
        unique: true # Apply unique constraint for the column, default `false`

      - name: address
        type: varchar
        length: 200 # specify length of the column