PomBuilder
Tables (6)
City
- cityId — varchar2(100) — Primary key — NOT NULL
- cityName — varchar2(100)
- countryId — varchar2(100) — Foreign key → Country.countryId — NOT NULL
Continent
- continentId — varchar2(100) — Primary key — NOT NULL
- continentNam,e (continentName) — varchar2(100)
Country
- countryId — varchar2(100) — Primary key — NOT NULL
- countryName — varchar2(100)
- continentId — varchar2(100) — Foreign key → Continent.continentId — NOT NULL
- landTypeId — varchar2(100) — Foreign key → LandType.landTypeId — NOT NULL
LandType
- landTypeId — varchar2(100) — Primary key — NOT NULL
- landTypeName — varchar2(100)
Student
- studId — varchar2(100) — Primary key — NOT NULL
- studName — varchar2(100)
- countryId — varchar2(100) — Foreign key → Country.countryId — NOT NULL
- univId — varchar2(100) — Foreign key → University.univId — NOT NULL
University
- univId — varchar2(100) — Primary key — NOT NULL
- univName — varchar2(100)
- countryId — varchar2(100) — Foreign key → Country.countryId — NOT NULL