States

Columns

Name	Type	Length	Precision	Scale	References	In	Description
country_id	NUMBER		39	0	country_id	Countries	Country ID
name	VARCHAR2	50					State name
short_name	VARCHAR2	36					State short name
state_id	NUMBER		38	0			State ID

Primary key

PK Column Name
state_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
states_countries_fk	country_id	Countries	country_id	1