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