CREATE TABLE dewan (
    userid CHAR(30) PRIMARY KEY,
    pwd VARCHAR(60) NOT NULL,
    created_on DATE NOT NULL,
    created_by CHAR(30),
    first_name CHAR(130),
    middle_name CHAR(130),
    last_name CHAR(130),
    role CHAR(100),
    valid_from DATE,
    valid_to DATE,
    ipaddress INET
);