Column Constraints - ERDL Diagram Syntax

• NULL or NOT NULL keyword to specify the column is optional
• IDENTITY keyword to indicate the column is incremental field
• DEFAULT() keyword to specify the default value

Customer
-
CustomerID int PK IDENTITY
Name string DEFAULT('NA')
Address1 string NOT NULL
Address2 string NULL
Address3 string NULL