Clinical

1
FORM
Clinical
Demographic
MASTER
FORM_EVENT
FORM_ID NUMBER(5)
SUBJECT_ID NUMBER(38)
FORM_EVENT_ID NUMBER
FORM_NAME VARCHAR2(50)
COLLECT_SITE_ID NUMBER(3) (FK)
FORM_VERSION VARCHAR2(20)
EVENT_DATE DATE
COLLECT_DATE DATE
FORM_DESC VARCHAR2(500)
FORM_ID NUMBER(5) (FK)
SEX VARCHAR2(200)
SUBJECT
SUBJECT_ID NUMBER(38) (FK)
FATHER_ID NUMBER(8)
SUBJECT_ID NUMBER(38) (FK)
MOTHER_ID NUMBER(8)
ETHNICITY VARCHAR2(20)
FIRST_NAME VARCHAR2(50)
FORM_QUESTION
COHORT NUMBER(5)
MIDDLE_NAME VARCHAR2(50)
RESPONSE
FORM_ID NUMBER(5) (FK)
TWIN_FLAG VARCHAR2(200)
LAST_NAME VARCHAR2(50)
QUESTION_ID NUMBER(10) (FK)
DEATH_FLAG VARCHAR2(3)
QUESTION_ID NUMBER(10) (FK)
NIDA_SHARE CHAR(1)
FORM_EVENT_ID NUMBER (FK)
DISPLAY_ORDER NUMBER(10)
MARITAL_STATUS CHAR(1)
SUBJECT_ID NUMBER(38) (FK)
ADMITTING_MD VARCHAR2(50)
ANSWER1_ID NUMBER(5) (FK)
BOND1998_CATEGORY CHAR(1)
FREEFORM_ANSWER1 VARCHAR2(4000)
ENTRY1_DONE CHAR(1)
QUESTION
ENTRANT1_ID NUMBER(5) (FK)
ENTRY1_DONE_DATE DATE
QUESTION_ID NUMBER(10)
ENTRY1_DATE DATE
ENTRY1_DONE_USER NUMBER(5) (FK)
ANSWER2_ID NUMBER(5) (FK)
ENTRY2_DONE CHAR(1)
ANSWER_GROUP_ID NUMBER(10) (FK)
FREEFORM_ANSWER2 VARCHAR2(4000)
ENTRY2_DONE_DATE DATE
QUEST_NAME VARCHAR2(200)
ENTRANT2_ID NUMBER(5) (FK)
ENTRY2_DONE_USER NUMBER(5) (FK)
QUEST_TEXT VARCHAR(1000)
ENTRY2_DATE DATE
ASI_SOURCE VARCHAR2(20)
FREEFORM CHAR(1)
VALIDATE_ANSWER_ID NUMBER(5)
VALIDATE_FREEFORM_ANSWER VARCHAR2(4000)
VALIDATOR_ID NUMBER(5) (FK)
ANSWER_GROUP
VALIDATE_DATE DATE
CREATE_DATE DATE
ANSWER_GROUP_ID NUMBER(10)
CREATE_USER_ID NUMBER(5) (FK)
ANSWER_GROUP_NAME VARCHAR2(500)
UPDATE_DATE DATE
UPDATE_USER_ID NUMBER(5) (FK)
ANSWER_GROUP_DETAIL
TEST
ANSWER_GROUP_ID NUMBER(10) (FK)
TEST_ID NUMBER(38)
ANSWER_ID NUMBER(5) (FK)
SUBJECT_ID NUMBER(38) (FK)
TEST_DATE DATE
COLLECT_SITE
ANSWER
COLLECT_SITE_ID NUMBER(3)
RESULT
ANSWER_ID NUMBER(5)
FACILITY VARCHAR2(100)
TEST_ID NUMBER(38) (FK)
CITY VARCHAR2(100)
ANSWER_VALUE VARCHAR2(50)
STATE VARCHAR2(100)
ENDOCRINE VARCHAR2(50)
COUNTRY VARCHAR2(100)
LEVEL NUMBER
METHOD
Security
Genetic
METHOD_ID NUMBER(5)
FORM_SIGNOFF
GENOTYPE_RESULT
METHOD_NAME VARCHAR2(50)
FORM_ID NUMBER(5) (FK)
METHOD_DESC VARCHAR2(500)
SUBJECT_ID NUMBER(38) (FK)
GENOTYPE_RESULT_ID NUMBER(38)
SUBJECT_ID NUMBER(38) (FK)
USER_ID1 NUMBER(5)
ENTRY1_DATE DATE
VARIANT_ID NUMBER(38) (FK)
USER_ID2 NUMBER(5)
METHOD_ID NUMBER(5) (FK)
ENTRY2_DATE DATE
RESEARCHER_ID NUMBER(5) (FK)
USER
VALIDATOR_ID NUMBER(5)
EXPERIMENT_DATE DATE
VALIDATE_DATE DATE
USE_FLAG VARCHAR2(3)
USER_ID NUMBER(5)
NOCHART_ID NUMBER(5)
CREATE_DATE DATE
USER_NAME VARCHAR2(20)
NOCHART_DATE DATE
CREATE_USER_ID NUMBER(5) (FK)
FIRST_NAME VARCHAR2(30)
UPDATE_DATE DATE
GENE
USER_PASSWORD VARCHAR2(50)
UPDATE_USER_ID NUMBER(5) (FK)
GROUP
GENE_ID NUMBER(38)
MIDDLE_NAME VARCHAR2(30)
ALLELE1 VARCHAR2(50)
GROUP_ID NUMBER(3)
LAST_NAME VARCHAR2(30)
CHROMOSOME_NUMBER VARCHAR2(10).
ALLELE2 VARCHAR2(50)
GENE_NAME VARCHAR2(50)
USER_EMAIL VARCHAR2(50)
GROUP_NAME VARCHAR2(50)
COMMON_NAME VARCHAR2(500)
PHONE VARCHAR2(20)
AFFILIATION VARCHAR2(50)
CHROMOSOME_START NUMBER(10)
ADDRESS VARCHAR2(100)
CHROMOSOME_STOP NUMBER(10)
ADMIN_FLAG VARCHAR2(3)
VARIANT
OMIM_NUMBER VARCHAR2(50)
CREATE_DATE DATE
USER_GROUP
VARIANT_ID NUMBER(38)
DB_ID NUMBER(8) (FK)
CREATE_USER_ID NUMBER(5)
NOTE VARCHAR2(1000)
USER_ID NUMBER(5) (FK)
VARIANT_NAME VARCHAR2(100)
UPDATE_DATE DATE
GROUP_ID NUMBER(3) (FK)
GENE_ID NUMBER(38) (FK)
EXON_INTRON_LOC VARCHAR2(50)
ROLE_ID NUMBER(3) (FK)
AUDIT_TABLE
NUCLEOTIDE_LOC VARCHAR2(50)
UPSTREAM_SEQ VARCHAR(50)
ID INTEGER
DOWNSTREAM_SEQ VARCHAR(50)
LOG_TIMESTAMP DATE
NOTE VARCHAR2(1000)
ROLE
USER_NAME VARCHAR(20)
VARIANT_TYPE VARCHAR2(20)
DBSNP_LOOKUP
ROLE_ID NUMBER(3)
OBJECT_NAME VARCHAR(20)
DB_ID NUMBER(5)
DBSNP_ID VARCHAR(20)
ACTION VARCHAR(20)
ROLE_NAME VARCHAR2(50)
DATA VARCHAR(20)
VARIANT_ID NUMBER(38) (FK)
ORGANISM VARCHAR2(100)
ALLELE_VALIDS
MOLECULAR_TYPE VARCHAR2(50)
ROLE_PERM
PERMISSION
CREATED_IN_BUILD NUMBER
VARIANT_ID NUMBER(38) (FK)
ROLE_ID NUMBER(3) (FK)
UPDATED_IN_BUILD NUMBER
PERMISSION_ID NUMBER(3)
ALLELE_ID NUMBER(10)
PERMISSION_ID NUMBER(3) (FK)
VARIATION_CLASS VARCHAR2(50)
VALID_ALLELE_VALUE VARCHAR(30)
PERMISSION_NAME VARCHAR2(50)
SEQUENCE VARCHAR2(4000)