SQLize Online / PHPize Online  /  SQLtest Online

localhost:5432 globoblanco@savvywalletdb=# \d customers.customers Table "customers.customers" Column | Type | Collation | Nullable | Default ---------------+-----------------------------+-----------+----------+-------------------- customer_id | uuid | | not null | uuid_generate_v4() title | character varying(10) | | | first_name | character varying(100) | | not null | middle_name | character varying(100) | | | last_name | character varying(100) | | not null | gender | character(1) | | | 'F'::bpchar date_of_birth | date | | | role_id | integer | | | created_ts | timestamp without time zone | | | CURRENT_TIMESTAMP created_by | character varying(50) | | | CURRENT_USER updated_ts | timestamp without time zone | | | updated_by | character varying(50) | | | deleted_ts | timestamp without time zone | | | Indexes: "customers_pkey" PRIMARY KEY, btree (customer_id) Triggers: customer_stamp BEFORE UPDATE ON customers FOR EACH ROW EXECUTE FUNCTION customer_stamp()