Scribd
Upload
8 views1 page

GGCMD 4

The document outlines the SQL command to create a table named 'backend_users' with various fields including user identification, personal information, login credentials, and user roles. It specifies data types for each column and includes constraints such as NOT NULL for essential fields. The table is designed to manage user data for a backend system.

Uploaded by

suchindran kannan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
8 views1 page

GGCMD 4

The document outlines the SQL command to create a table named 'backend_users' with various fields including user identification, personal information, login credentials, and user roles. It specifies data types for each column and includes constraints such as NOT NULL for essential fields. The table is designed to manage user data for a backend system.

Uploaded by

suchindran kannan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

CREATE TABLE backend_users (

id NUMBER(10,0) GENERATED BY DEFAULT ON NULL AS IDENTITY START WITH 0 INCREMENT


BY 1 MINVALUE 0 NOMAXVALUE ,
first_name VARCHAR2(191 CHAR),
last_name VARCHAR2(191 CHAR),
login VARCHAR2(191 CHAR) NOT NULL,
email VARCHAR2(191 CHAR) NOT NULL,
password VARCHAR2(191 CHAR) NOT NULL,
activation_code VARCHAR2(191 CHAR),
persist_code VARCHAR2(191 CHAR),
reset_password_code VARCHAR2(191 CHAR),
permissions CLOB,
is_activated NUMBER(3,0) NOT NULL,
role_id NUMBER(10,0),
activated_at DATE,
last_login DATE,
created_at DATE,
updated_at DATE,
deleted_at DATE,
is_superuser NUMBER(3,0) NOT NULL,
user_type NUMBER(10,0) NOT NULL,
user_data CLOB,
employee_record_id VARCHAR2(191 CHAR),
team_id NUMBER(10,0),
designation VARCHAR2(200 CHAR),
phone VARCHAR2(200 CHAR),
is_admin NUMBER(3,0) NOT NULL,
old_id VARCHAR2(100 CHAR),
old_password VARCHAR2(200 CHAR),
is_sso NUMBER(3,0) NOT NULL,
allowed_ct CLOB,
secure_login NUMBER(3,0) NOT NULL
);

You might also like