First page Back Continue Last page Image

Tables have Columns and Columns can have Attributes

Database:stargate

stargateships

Tables are created by defining their primary building block:Columns

shipid

shipname

complement

shipsize

powersource

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Data

Each Column could have one or more of 4 attributes

NOT NULL

UNIQUE

DEFAULT

AUTO_INCREMENT

The Field must have a value

Default value added at creation

The system will assign numbers

Contents in each record is unique