vehicle_owners.sql

CREATE TABLE admintools.vehicle_owners (
	id int4 NOT NULL DEFAULT nextval('admintools.vehicle_owners_id_seq'::regclass),
	first_name varchar(40) NOT NULL,
	last_name varchar(40) NOT NULL,
	nic varchar(20) NOT NULL,
	email varchar(100) NULL,
	address jsonb NULL,
	contact_numbers jsonb NOT NULL,
	CONSTRAINT vehicle_owners_first_name_check CHECK((first_name)::text <> ''::text),
	CONSTRAINT vehicle_owners_last_name_check CHECK((last_name)::text <> ''::text),
	CONSTRAINT vehicle_owners_nic_check CHECK((nic)::text <> ''::text),
	CONSTRAINT vehicle_owners_nic_key UNIQUE (nic),
	CONSTRAINT vehicle_owners_pkey PRIMARY KEY (id)
)
WITH (
	OIDS=FALSE
);