Last active
May 31, 2021 13:28
-
-
Save shrinivdeshmukh/4b14612d46f4ed5a78d3cdc5b41fb1e9 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment