# Purpose: `This SQL code is to be used along side the Getting Started Guide # to setup the OS AddressBase tables within a database ...
CREATE TABLE PUPIL ( PupilID CHAR(9) PRIMARY KEY CHECK (PupilID LIKE 'P_____'), PupilName NVARCHAR2(30) NOT NULL, ClassID CHAR(5) NOT NULL, DateOfBirth DATE NOT NULL, Gender NVARCHAR2(4) NOT NULL, ...