By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE st(
EMPLOYE_ID TEXT primary key ,
EMPLOYE_Name text NOT NULL ,
father_name text NOT NULL,
cnic INTEGER NOT NULL,
DOB real not null,
address text not null,
username text not null,
password text not null,
post text not null
CHECK(
typeof(employe_id)='text'
AND length(employe_id)<=10
and typeof(employe_name)='text'
AND length(employe_name)<=100
and typeof(father_name)='text'
AND length(father_name)<=100
and typeof(cnic)='integer'
AND length(cnic)=13
and typeof(address)='text'
and length(address)<=200
and typeof(username)='text'
and length(username)<=10
and typeof(password)='text'
and length(password)<=20
)
);
insert into st(employe_id, employe_name, father_name, cnic, DOB, address, username, password,post)
values('a1','jamshaid','iqbal',1110332507339,julianday('1998-10-05'),'26 eb rehmkot','a1','a1','Admin');
SELECT * FROM st;
| EMPLOYE_ID | EMPLOYE_Name | father_name | cnic | DOB | address | username | password | post |
|---|---|---|---|---|---|---|---|---|
| a1 | jamshaid | iqbal | 1110332507339 | 2451091.5 | 26 eb rehmkot | a1 | a1 | Admin |