Entity Country

Description of Entity Country

This entity holds records of the different countries. It only stores the code and name for the country. This entity can be used in any place that involves the particular country.

Example: Country of birth in the Personal entity and the country of the company. It may also be used in the address section as the country of the address.

As this is a look up table and will not be linked to any other entity, the application will then have to control the changes made to this entity.


List of all Dependencies of the Entity Country

Name

Code

Class Name

Relation_3307

Relation_3307

Reference

Relation_49034

Relation_49034

Reference


List of Attributes of the Entity Country

Name

Code

Country ID

CountryId

Country Name

CountryName

Country Tel Code

CountryTelCode

Country Nationality

CountryNationality

Country Currency

CountryCurrency


Entity Attribute Country ID of the Entity Country

Card of Attribute Country ID of the Entity Country

Name

Country ID

Code

CountryId

Data Type

char(20)

Mandatory

Yes


Description of Attribute Country ID of the Entity Country

Shows the identity of the country. It is unique for each country. It is also the primary key for the Country table.
Example: USA (United States of America) / UK (United Kingdom) / SIN (Singapore)


Entity Attribute Country Name of the Entity Country

Card of Attribute Country Name of the Entity Country

Name

Country Name

Code

CountryName

Data Type

char(60)

Mandatory

No


Description of Attribute Country Name of the Entity Country

Shows the full name of the country.
Example: United States of America / United Kingdom / Singapore


Entity Attribute Country Tel Code of the Entity Country

Card of Attribute Country Tel Code of the Entity Country

Name

Country Tel Code

Code

CountryTelCode

Data Type

char(20)

Mandatory

Yes


Description of Attribute Country Tel Code of the Entity Country

Stores the telephone code for telecommunication for each country.
Example: Singapore = 65 / Australia = 61 / Malaysia = 60


Entity Attribute Country Nationality of the Entity Country

Card of Attribute Country Nationality of the Entity Country

Name

Country Nationality

Code

CountryNationality

Data Type

char(100)

Mandatory

No


Description of Attribute Country Nationality of the Entity Country

Shows the nationality for the country.
Example: Australian / Malaysian / British


Entity Attribute Country Currency of the Entity Country

Card of Attribute Country Currency of the Entity Country

Name

Country Currency

Code

CountryCurrency

Data Type

char(20)

Mandatory

No


Description of Attribute Country Currency of the Entity Country

Stores the currency for the country.
Example: Singapore = SGD / Australia = AUD / Vietnam = VND