We can specify our own data type to use in the schema.

CREATE DOMAIN SSN AS CHAR(9);
CREATE TABLE DEPARTMENT (MGRSSN SSN, ...);

We need to CREATE DOMAIN before utilising it in CREATE TABLE.