SAMPLE DATABASE STRUCTURE IN ORACLE

THIS IS SAMPLE DATABASE STRUCTURE IN ORACLE



CREATE TABLE IMAGETABLE.ASDF ( 
CARDNUM       VARCHAR2(255) NULL,
NUMBER         VARCHAR2(22) NULL,
ENNAME         NCHAR(250) NULL,
NAME         VARCHAR2(100) NOT NULL,
NAME NCHAR(200) NULL 
)
GO
CREATE TABLE IMAGETABLE.EMPLO_RESULTS ( 
ORIGINAL_ID     VARCHAR2(255) NULL,
ORIGINAL_MEMBERID       VARCHAR2(20) NULL,
VIEW_STATUS             NUMBER(38,0) NOT NULL,
EMPLO_STATUS             NUMBER(38,0) NOT NULL,
CLOSE_TIME               TIMESTAMP(6) NULL,
PHOTO_STATUS             NUMBER(38,0) NULL,
PERSDETAILSTATUS       NUMBER(38,0) NULL,
ADDRSTATUS             NUMBER(38,0) NULL,
BOARD_STATUS             NUMBER(38,0) NULL,
MEMBER_STATUS           NUMBER(38,0) NULL,
REMARKS                 VARCHAR2(200) NULL,
TOTMEMBERINPHOTO_DUP   NUMBER(38,0) NULL,
DUP_TOTMEMBERMATCH       NUMBER(38,0) NULL,
MATCHED_CONDITIONS       VARCHAR2(50) NULL,
USER_CODE             VARCHAR2(20) NULL,
EMPLO_STATUS           NUMBER(38,0) NOT NULL,
OPEN_TIME             TIMESTAMP(6) NULL,
CLOSE_TIME             TIMESTAMP(6) NULL,
PERSDETAILSTATUS     NUMBER(38,0) NULL,
REMARKS               VARCHAR2(200) NULL,
MATCHED_CONDITIONS     VARCHAR2(50) NULL,
EMPLOID                 NUMBER(38,0) NOT NULL,
SNO                     NUMBER NULL,
ORG_ENR_URN             VARCHAR2(25) NULL,
DUP_ENR_URN             VARCHAR2(25) NULL,
RECORD_STATUS           DATE NULL,
)
GO
CREATE TABLE IMAGETABLE.LOGIN ( 
SNO       NUMBER(38,0) NULL,
USERNAME VARCHAR2(50) NULL,
PASSWORD VARCHAR2(200) NULL,
NAME     VARCHAR2(50) NULL,
USERTYPE VARCHAR2(30) NULL,
CODE NUMBER(38,0) NULL 
)
GO
CREATE TABLE IMAGETABLE.LOGIN_LOG ( 
SNO       NUMBER(38,0) NULL,
USERCODE NUMBER(38,0) NULL,
LOGINTYPE VARCHAR2(10) NULL,
TIME     TIMESTAMP(6) NULL 
)
GO
CREATE TABLE IMAGETABLE.MIGID ( 
ID VARCHAR2(255) NULL 
)
GO
CREATE TABLE IMAGETABLE.BLOCK ( 
TALUK_CODE   FLOAT NOT NULL,
DISTRICT_CODE FLOAT NULL,
TALUK_NAME   NVARCHAR2(250) NULL,
TALUK_ENAME   VARCHAR2(30) NULL 
)
GO
CREATE TABLE IMAGETABLE.DISTRICT ( 
DISTRICT_CODE FLOAT NOT NULL,
DIST_NAME     VARCHAR2(30) NULL,
DIST_TNAME   NCHAR(75) NULL 
)
GO
CREATE TABLE IMAGETABLE.TABLE1 ( 
ORG VARCHAR2(20) NOT NULL,
DUP VARCHAR2(20) NULL,
MIG VARCHAR2(20) NULL 
)
GO
CREATE TABLE IMAGETABLE.DEPEND ( 
SNO             NUMBER(10,0) NOT NULL,
MEMBERID         NUMBER(10,0) NOT NULL,
APPLICATIONNO   VARCHAR2(50) NULL,
NAME   NCHAR(200) NULL,
RELATIONSHIPCODE VARCHAR2(5) NULL,
AGE             NUMBER(3,0) NULL,
GENDER           VARCHAR2(10) NULL,
ID     VARCHAR2(100) NOT NULL 
)
GO
CREATE TABLE IMAGETABLE.ENROL ( 
SERIALNO           VARCHAR2(10) NOT NULL,
APPLICANTNAMELOCAL NCHAR(250) NULL,
FATHERNAME         NCHAR(200) NULL,
DOORNO             VARCHAR2(200) NULL,
ADDRESS       NCLOB NULL,
WARDCODE           VARCHAR2(10) NULL,
OLDDOORNO         NCHAR(150) NULL,
CARDNUMBER         VARCHAR2(25) NULL,
ACTIVESTATUS       NUMBER(10,0) NULL,
BOARD             NCHAR(25) NULL,
MEMBERID           VARCHAR2(15) NULL,
ENROLLED           CHAR(10) NULL,
ID       VARCHAR2(100) NOT NULL,
MIGRATIONTIME     DATE NULL,
POVID             VARCHAR2(13) NULL,
)
GO
CREATE TABLE IMAGETABLE.TRANSACTIONS ( 
TRANSACTION_ID   NUMBER NOT NULL,
TRANSACTION_DATE DATE NOT NULL,
TRANSACTION_TYPE NUMBER NOT NULL 
)
GO
CREATE TABLE IMAGETABLE.PHOTO ( 
URN                 VARCHAR2(70) NOT NULL,
FAMILYPHOTOPATHGRAPH    BLOB NULL,
HEADPHOTO   VARCHAR2(300) NULL,
FAMILYPHOTOPATH VARCHAR2(300) NULL,
ID         VARCHAR2(255) NOT NULL 
)
GO
CREATE TABLE IMAGETABLE.V_URN ( 
CARDNUM       VARCHAR2(255) NULL,
ENNAME         NCHAR(250) NULL,
MIGID         VARCHAR2(100) NOT NULL,
NAME NCHAR(200) NULL,
ROWNO         NUMBER NULL 
)
GO