WIGIS2018
Tables (175)
SG_BIOSEQUENCE_HIST
- ENT_OID — NUMBER — NOT NULL
- HIST_VER — NUMBER — NOT NULL
- VERSION — NUMBER
- LENGTH — NUMBER
- ALPHABET — VARCHAR2
- SEQ — CLOB
- CRC — VARCHAR2
SG_COMMENT
- OID — NUMBER — NOT NULL
- RANK — NUMBER — NOT NULL
- COMMENT — ON — NOT NULL — N WIGIS2015.SG_COMMENT _TEXT CLOB NOT NULL ENT_OID NUMBER (*, 0) NOT NULL ) PCTFREE 10 PCTUSED 40 TABLESPACE WIGIS2014_…
SG_DBXREF
- OID — NUMBER — Primary key — NOT NULL
- DBNAME — VARCHAR2 — NOT NULL
- ACCESSION — VARCHAR2 — NOT NULL
- VERSION — NUMBER — NOT NULL
SG_DBXREF_HIST
- HIST_VER — NUMBER — Primary key — NOT NULL
- OID — NUMBER — Primary key — NOT NULL
- DBNAME — VARCHAR2 — NOT NULL
- ACCESSION — VARCHAR2 — NOT NULL
- VERSION — NUMBER — NOT NULL
SG_DBXREF_QUALIFIER_ASSOC
- RANK — NUMBER — Primary key — NOT NULL
- DBX_OID — NUMBER — Foreign key → SG_DBXREF.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- VALUE — VARCHAR2
SG_LOCATION
- OID — NUMBER — Primary key — NOT NULL
- START_POS — NUMBER
- END_POS — NUMBER
- STRAND — NUMBER — NOT NULL
- RANK — NUMBER — NOT NULL
- FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- DBX_OID — NUMBER — Foreign key → SG_DBXREF.OID
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID
SG_LOCATION_HIST
- HIST_VER — NUMBER — Primary key — NOT NULL
- OID — NUMBER — Primary key — NOT NULL
- START_POS — NUMBER
- END_POS — NUMBER
- STRAND — NUMBER — NOT NULL
- RANK — NUMBER — NOT NULL
- FEA_OID — NUMBER — NOT NULL
- DBX_OID — NUMBER
- TRM_OID — NUMBER
SG_LOCATION_QUALIFIER_ASSOC
- LOC_OID — NUMBER — Foreign key → SG_LOCATION.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- VALUE — VARCHAR2 — NOT NULL
SG_ONTOLOGY
- OID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR2 — NOT NULL
- DEFINITION — VARCHAR2
SG_REFERENCE
- OID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2
- AUTHORS — VARCHAR2 — NOT NULL
- LOCATION — VARCHAR2 — NOT NULL
- CRC — VARCHAR2
- DBX_OID — NUMBER — Foreign key → SG_DBXREF.OID
SG_REFERENCE_HIST
- HIST_VER — NUMBER — Primary key — NOT NULL
- OID — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2
- AUTHORS — VARCHAR2 — NOT NULL
- LOCATION — VARCHAR2 — NOT NULL
- CRC — VARCHAR2
- DBX_OID — NUMBER
SG_SEQFEATURE
- OID — NUMBER — Primary key — NOT NULL
- RANK — NUMBER — NOT NULL
- DISPLAY_NAME — VARCHAR2
- ENT_OID — NUMBER — NOT NULL
- TYPE_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- SOURCE_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
SG_SEQFEATURE_ASSOC
- OID — NUMBER — Primary key — NOT NULL
- SUBJ_FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- OBJ_FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- RANK — NUMBER — NOT NULL
SG_SEQFEATURE_DBXREF_ASSOC
- DBX_OID — NUMBER — Foreign key → SG_DBXREF.OID — NOT NULL
- FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- RANK — NUMBER
SG_SEQFEATURE_HIST
- HIST_VER — NUMBER — Primary key — NOT NULL
- OID — NUMBER — Primary key — NOT NULL
- RANK — NUMBER — NOT NULL
- DISPLAY_NAME — VARCHAR2
- ENT_OID — NUMBER — NOT NULL
- TYPE_TRM_OID — NUMBER — NOT NULL
- SOURCE_TRM_OID — NUMBER — NOT NULL
SG_SEQFEATURE_PATH
- SUBJ_FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- OBJ_FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- DISTANCE — NUMBER
SG_SEQFEATURE_QUALIFIER_ASSOC
- RANK — NUMBER — Primary key — NOT NULL
- FEA_OID — NUMBER — Foreign key → SG_SEQFEATURE.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- VALUE — VARCHAR2
SG_SEQFEATURE_QUAL_ASSOC_HIST
- FEA_OID — NUMBER — Primary key — NOT NULL
- TRM_OID — NUMBER — Primary key — NOT NULL
- RANK — NUMBER — Primary key — NOT NULL
- HIST_VER — NUMBER — Primary key — NOT NULL
- VALUE — VARCHAR2
SG_SIMILARITY
- OID — NUMBER — Primary key — NOT NULL
- SCORE — NUMBER
- EXPECT_MANTISSA — FLOAT
- EXPECT_EXPONENT — NUMBER
- PCT_IDENTITY — NUMBER
- PCT_COVERAGE — NUMBER
- SUBJ_START_POS — NUMBER — NOT NULL
- SUBJ_END_POS — NUMBER — NOT NULL
- SUBJ_STRAND — NUMBER
- SUBJ_FRAME — NUMBER
- OBJ_START_POS — NUMBER — NOT NULL
- OBJ_END_POS — NUMBER — NOT NULL
- OBJ_STRAND — NUMBER
- OBJ_FRAME — NUMBER
SG_TAXON
- OID — NUMBER — Primary key — NOT NULL
- NCBI_TAXON_ID — NUMBER
- NODE_RANK — VARCHAR2
- GENETIC_CODE — NUMBER
- MITO_GENETIC_CODE — NUMBER
- LEFT_VALUE — NUMBER
- RIGHT_VALUE — NUMBER
- TAX_OID — NUMBER
SG_TAXON_NAME
- TAX_OID — NUMBER — Foreign key → SG_TAXON.OID — NOT NULL
- NAME — VARCHAR2 — NOT NULL
- NAME_CLASS — VARCHAR2 — NOT NULL
SG_TERM
- OID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR2 — NOT NULL
- IDENTIFIER — VARCHAR2
- DEFINITION — VARCHAR2
- IS_OBSOLETE — VARCHAR2
- ONT_OID — NUMBER — Foreign key → SG_ONTOLOGY.OID — NOT NULL
SG_TERM_ASSOC
- OID — NUMBER — Primary key — NOT NULL
- SUBJ_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- PRED_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- OBJ_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- ONT_OID — NUMBER — Foreign key → SG_ONTOLOGY.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID
SG_TERM_DBXREF_ASSOC
- DBX_OID — NUMBER — Foreign key → SG_DBXREF.OID — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- RANK — NUMBER
SG_TERM_HIST
- HIST_VER — NUMBER — Primary key — NOT NULL
- OID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR2 — NOT NULL
- IDENTIFIER — VARCHAR2
- DEFINITION — VARCHAR2
- IS_OBSOLETE — VARCHAR2
- ONT_OID — NUMBER — NOT NULL
SG_TERM_PATH
- OID — NUMBER — Primary key — NOT NULL
- SUBJ_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- PRED_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- OBJ_TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
- DISTANCE — NUMBER — NOT NULL
- ONT_OID — NUMBER — Foreign key → SG_ONTOLOGY.OID — NOT NULL
SG_TERM_SYNONYM
- NAME — VARCHAR2 — Primary key — NOT NULL
- TRM_OID — NUMBER — Foreign key → SG_TERM.OID — NOT NULL
T_COM_ATTCH_FILE
- FILE_ID — VARCHAR2 — Primary key — NOT NULL
- FILE_SEQ — NUMBER — Primary key — NOT NULL
- FILE_NM — VARCHAR2 — NOT NULL
- FILE_SIZE — FLOAT
- FILE_MASK — VARCHAR2 — NOT NULL
- DWLD_CNT — NUMBER
- DWLD_EXPIRE_DATE — VARCHAR2
- DWLD_LIMIT_CNT — NUMBER
- DEL_YN — CHAR — NOT NULL
- REGIST_USER_ID — VARCHAR2 — NOT NULL
- REGIST_DT — DATE — NOT NULL
WIGIS_ADDRESS
- ID — NUMBER
- ZIPCODE — CHAR
- ILNUM — CHAR
- SIDO — VARCHAR2
- SIGUGUN — VARCHAR2
- DONG — VARCHAR2
- RI — VARCHAR2
- DOSEO — VARCHAR2
- BUNJI — VARCHAR2
- APART — VARCHAR2
WIGIS_AUTH
- AUTH_GROUP_SEQ — NUMBER — NOT NULL
- AUTH_GROUP_NM — VARCHAR2
- AUTH_GROUP_DESC — VARCHAR2
- USE_YN — CHAR
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
- AUTH_CLASS_CODE — VARCHAR2
WIGIS_AUTH_LINK
- AUTH_GROUP_SEQ — VARCHAR2 — NOT NULL
- AUTH_GROUP_NM — VARCHAR2
- AUTH_GROUP_DESC — VARCHAR2
- USE_YN — CHAR
- REG_DT — DATE
- REG_ID — VARCHAR2
- MOD_DT — DATE
- MOD_ID — VARCHAR2
- AUTH_CLASS_CODE — VARCHAR2
WIGIS_BATCH
- BATCH_SEQ — NUMBER — Primary key — NOT NULL
- EXCEL_FILE — NVARCHAR2 — NOT NULL
- ORIGIN_EXCEL_FILE — NVARCHAR2 — NOT NULL
- CTIME — TIMESTAMP
- EMPID — VARCHAR2
- PROJECT_ID — NUMBER — NOT NULL
- OPEN_DATE — TIMESTAMP — NOT NULL
- FILE_ID — VARCHAR2
- F_CNT — NUMBER
- S_CNT — NUMBER
- DEL_YN — CHAR
- CATEGORY — CHAR
- A_CNT — NUMBER
- KTSN — NUMBER
WIGIS_BATCH_DTL
- BATCH_DTL_SEQ — NUMBER — Primary key — NOT NULL
- BATCH_SEQ — NUMBER — NOT NULL
- VOUCHER — NVARCHAR2
- KTSN — NUMBER
- PROJECT_ID — NUMBER
- CTIME — TIMESTAMP
- EMPID — VARCHAR2
- DEL_YN — CHAR
WIGIS_BATCH_DTL_BARCODE
- BATCH_DTL_SEQ — NUMBER — Primary key — NOT NULL
- BATCH_SEQ — NUMBER — NOT NULL
- SEQ — CLOB
- ORG_FILE_NM — NVARCHAR2
- MARKER_ID — NUMBER
- PR_SET_ID — NUMBER
- PR_SET_NM — VARCHAR2
- PROJECT_ID — NUMBER
WIGIS_BATCH_DTL_OSTD_BASIC
- BATCH_DTL_SEQ — NUMBER — Primary key — NOT NULL
- BATCH_SEQ — NUMBER — NOT NULL
- PROJECT_ID — NUMBER
- SNP_MARKER_NM — VARCHAR2
- FIVE_PRIME — VARCHAR2
- THREE_PRIME — VARCHAR2
- SLICE_SEQ — VARCHAR2
- ALLELE_OBSERVATION — VARCHAR2
- ALLELE_POSITION — VARCHAR2
- ALLELE_FREQUENCY_RATE — VARCHAR2
- MS_MARKER_NM — VARCHAR2
- REPEAT_MOTIF — VARCHAR2
- FORWARD_PRIMER_SEQ — VARCHAR2
- REVERSE_PRIMER_SEQ — VARCHAR2
- TMF — VARCHAR2
- TMR — VARCHAR2
- EXPEXTED_ALLELE_SIZE — VARCHAR2
- GENBANK_ACCESSION_NO — VARCHAR2
- FLUORESCENSE_LABEL — VARCHAR2
WIGIS_BATCH_DTL_OSTD_MS_SIZE
- BATCH_DTL_SEQ — NUMBER — Primary key — NOT NULL
- OSTD_BASIC_MS_ID — VARCHAR2 — Primary key — NOT NULL
- BATCH_SEQ — NUMBER — NOT NULL
- ALLELE_SIZE — VARCHAR2
WIGIS_BLAST
- BLAST_ID — VARCHAR2 — Primary key — NOT NULL
- STTS_CD — VARCHAR2 — NOT NULL
- START_DT — DATE
- END_DT — DATE
- REGIST_DT — DATE — NOT NULL
- HWUSAGE — VARCHAR2
WIGIS_BLAST_RST
- BLAST_RST_ID — NUMBER — Primary key — NOT NULL
- BLAST_ID — VARCHAR2 — Foreign key → WIGIS_BLAST.BLAST_ID — NOT NULL
- IDENTITY — VARCHAR2
- COVERAGE — VARCHAR2
- QUERY_START — VARCHAR2
- QUERY_END — VARCHAR2
- SUBJECT_START — VARCHAR2
- SUBJECT_END — VARCHAR2
- E_VALUE — VARCHAR2
- SCORE — VARCHAR2
- RANKING — NUMBER — NOT NULL
- SEQ_DAT — CLOB
- SEQ_DESC — VARCHAR2
- REGIST_DT — DATE — NOT NULL
- ACCESSION — VARCHAR2
- ALIGN_MENT — CLOB
- MAKER_NAME — VARCHAR2
- RST_CODE — VARCHAR2
WIGIS_BOARD_COMMENT
- ID — NUMBER — NOT NULL
- REG_ID — NUMBER
- REG_DT — DATE
- COMMENT — ON — N COLUMN WIGIS2015.WIGIS_CITES.SP_NM IS '학명' S VARCHAR2 (4000 BYTE) IP_ADDR VARCHAR2 (20 BYTE
- IS_DEL — CHAR
- BOARD_NAME — VARCHAR2
- BOARD_SEQ — NUMBER
- ATTACH_FILE_NM — VARCHAR2
- ATTACH_ORGIN_FILE_NM — VARCHAR2
- EMPID — VARCHAR2
WIGIS_CITES_GENBANK_SEQ
- SEQ_ID — NUMBER — Primary key — NOT NULL
- LOCUS_ID — VARCHAR2 — NOT NULL
- SEQ_DESC — VARCHAR2
- ORANISM — VARCHAR2
WIGIS_CITES_SEQ
- CITES_ID — NUMBER — Primary key — NOT NULL
- SEQ_ID — NUMBER — Primary key — NOT NULL
WIGIS_CODE
- CODE — VARCHAR2 — Primary key — NOT NULL
- GROUP_CODE — VARCHAR2 — Foreign key → WIGIS_GROUP.GROUP_CODE — NOT NULL
- CODE_NM — VARCHAR2
- USE_YN — CHAR
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
- COL_ORD — NUMBER
WIGIS_COMMON_EXCEPTION
- COMMON_EXCEPTION_SEQ — NUMBER — Primary key — NOT NULL
- COMMON_EXCEPTION — VARCHAR2
- COMMON_PACKAGE_NAME — VARCHAR2
- COMMON_CAUSE — VARCHAR2
- COMMON_DETAIL_MESSAGE — VARCHAR2
- COMMON_REQUEST_PARAM — VARCHAR2
- COMMON_CONTEXT_PATH — VARCHAR2
- COMMON_REQUEST_URL — VARCHAR2
- COMMON_REMOTE_ADDR — VARCHAR2
- COMMON_REMOTE_HOST — VARCHAR2
- COMMON_REMOTE_PORT — VARCHAR2
- REG_DT — DATE
- REG_ID — VARCHAR2
- MOD_DT — DATE
- MOD_ID — VARCHAR2
- COMMON_EXCEPTION_CLASS — VARCHAR2
- COMMON_STACKTRACE — VARCHAR2
WIGIS_EZBIO
- EZBIO_ID — VARCHAR2 — Primary key — NOT NULL
- TAXON_NM — VARCHAR2 — NOT NULL
- SEQ_DAT — CLOB — NOT NULL
- REGIST_USER_ID — VARCHAR2 — NOT NULL
- REGIST_DT — DATE — NOT NULL
- BLAST_ID — VARCHAR2
- API_JOB_ID — NUMBER
- KTSN_RST — NUMBER
- API_RST — NUMBER
- NIBR_RST — NUMBER
- UPDT_DT — DATE
- PROJECT_ID — VARCHAR2
- SEQ_DES — VARCHAR2
WIGIS_EZBIO_IDPLUS_API
- API_JOB_ID — NUMBER — Primary key — NOT NULL
- STTS_CD — VARCHAR2
- RST_DAT — CLOB
- REGIST_DT — DATE — NOT NULL
- UPDT_DT — DATE — NOT NULL
WIGIS_EZBIO_IDPLUS_API_RST
- API_JOB_ID — NUMBER — Primary key — NOT NULL
- API_RST_ID — NUMBER — Primary key — NOT NULL
- STRAIN_NAME — VARCHAR2
- TAXON_NAME — VARCHAR2
- TAXONOMY — VARCHAR2
- SIMILARITY — VARCHAR2
- ACCESSION — VARCHAR2
- COMPLETENESS — VARCHAR2
- AUTHORS — VARCHAR2
- NCOMPARED — VARCHAR2
- NMISMATCH — VARCHAR2
- TYPE — VARCHAR2
- VALID — VARCHAR2
WIGIS_EZBIO_KTSN
- EZBIO_ID — NUMBER — Primary key — NOT NULL
- KTSN — NUMBER — Primary key — NOT NULL
WIGIS_FRMT_DB
- FRMT_DB_ID — NUMBER — Primary key — NOT NULL
- SEQ_CNT — NUMBER
- FA_FILE_PATH — VARCHAR2
- MARKER_NAME — VARCHAR2
- FRMT_DB_PATH — VARCHAR2
- CTIME — DATE
- MTIME — DATE
- STTS_CD — VARCHAR2
- START_TIME — DATE
- END_TIME — DATE
WIGIS_FRMT_DB_HIST
- ID — NUMBER — Primary key — NOT NULL
- FRMT_DB_ID — NUMBER — Foreign key → WIGIS_FRMT_DB.FRMT_DB_ID — NOT NULL
- SEQ_CNT — NUMBER
- FA_FILE_PATH — VARCHAR2
- MARKER_NAME — VARCHAR2
- FRMT_DB_PATH — VARCHAR2
- CTIME — DATE
- MTIME — DATE
- STTS_CD — VARCHAR2
- START_TIME — DATE
- END_TIME — DATE
WIGIS_GEO_SERIES
- GEO_SERIES_ID — VARCHAR2 — Primary key — NOT NULL
- TITLE — VARCHAR2 — NOT NULL
- SUMMARY — VARCHAR2
- OVERALL_DESIGN — VARCHAR2
- CONTRIBUTOR — VARCHAR2
- URL — VARCHAR2
- PUBMED_ID — VARCHAR2
- VARIABLE — VARCHAR2
- REPEAT — VARCHAR2
WIGIS_GROUP
- GROUP_CODE — VARCHAR2 — Primary key — NOT NULL
- GROUP_NM — VARCHAR2
- USE_YN — CHAR
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
WIGIS_INSTITUTION
- ID — NUMBER — Primary key — NOT NULL
- ORGAN_NM — NVARCHAR2
- ORGAN_TY — NVARCHAR2
- STAFF — NVARCHAR2
- ADDRESS1 — NVARCHAR2
- ADDRESS2 — NVARCHAR2
- ZIPCODE — NVARCHAR2
- TEL — NVARCHAR2
- REG_ID — NUMBER
- REG_DT — DATE
- MOD_ID — NUMBER
- MOD_DT — DATE
WIGIS_INTRO
- ID — NUMBER — Primary key — NOT NULL
- USER_ID — NUMBER
- IP_ADDR — VARCHAR2
- CTIME — TIMESTAMP — NOT NULL
- MTIME — TIMESTAMP — NOT NULL
- CONTENT — CLOB
- EMPID — VARCHAR2
WIGIS_IP_CONNECT_LOG
- CONNECT_SEQ — NUMBER — Primary key — NOT NULL
- CONNECT_START_DATE — DATE
- CONNECT_END_DATE — DATE
- CONNECT_IP — VARCHAR2
- COUNTRY_SIGN — VARCHAR2
- DAY_CODE — VARCHAR2
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
- IP_ADDR — VARCHAR2
WIGIS_IP_URL_LOG
- PAGE_SEQ — NUMBER — Primary key — NOT NULL
- CONNECT_SEQ — NUMBER — Foreign key → WIGIS_IP_CONNECT_LOG.CONNECT_SEQ — NOT NULL
- URL — VARCHAR2
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
- IP_ADDR — VARCHAR2
WIGIS_KLTB_TAXON_FULL
- KTSN — NUMBER — Primary key — NOT NULL
- TAXON_FULL_NM — VARCHAR2
- TAXON_FULL_NM_EM — VARCHAR2
- RANK_ID — NUMBER
- STATUS — CHAR
- REL_TYPE — CHAR
- KTSN_J — NUMBER
- TAXON_TYPE — VARCHAR2
- SPECIES_TYPE — VARCHAR2
- SYN_JM_KTSN — NUMBER
- ORI_JM_KTSN — NUMBER
- ORIGIN_LIST — VARCHAR2
- ALTERNATIVE_KTSN — CHAR
- KTSN_P — NUMBER
- TAXON_NM — VARCHAR2
- TAXON_KNM — VARCHAR2
- COMM_GROUP — CHAR
- R200_NM — VARCHAR2
- R200_KNM — VARCHAR2
- R200_KTSN — NUMBER
- R300_NM — VARCHAR2
- R300_KNM — VARCHAR2
- R300_KTSN — NUMBER
- R310_NM — VARCHAR2
- R310_KNM — VARCHAR2
- R310_KTSN — NUMBER
- R400_NM — VARCHAR2
- R400_KNM — VARCHAR2
- R400_KTSN — NUMBER
- R500_NM — VARCHAR2
- R500_KNM — VARCHAR2
- R500_KTSN — NUMBER
- R600_NM — VARCHAR2
- R600_KNM — VARCHAR2
- R600_KTSN — NUMBER
- R610_NM — VARCHAR2
- R610_KNM — VARCHAR2
- R610_KTSN — NUMBER
- R700_NM — VARCHAR2
- R700_KNM — VARCHAR2
- R700_KTSN — NUMBER
- R710_NM — VARCHAR2
- R710_KNM — VARCHAR2
- R710_KTSN — NUMBER
- R720_NM — VARCHAR2
- R720_KNM — VARCHAR2
- R720_KTSN — NUMBER
- R730_NM — VARCHAR2
- R730_KNM — VARCHAR2
- R730_KTSN — NUMBER
- MAN_CD1 — VARCHAR2
- MAN_CD2 — VARCHAR2
- MAN_CD3 — VARCHAR2
- MAN_CD4 — VARCHAR2
- MAN_CD5 — VARCHAR2
- MAN_CD6 — VARCHAR2
- MAN_CD7 — VARCHAR2
- MAN_CD8 — VARCHAR2
- MAN_CD9 — VARCHAR2
- MAN_CD10 — VARCHAR2
- … +8
WIGIS_LOG
- SYSTEMNAME — VARCHAR2
- LOGDATE — DATE
- LOGLEVEL — VARCHAR2
- MDC1 — VARCHAR2
- MDC2 — VARCHAR2
- MESSAGE — VARCHAR2
- TROWABLE — VARCHAR2
WIGIS_LOGGER
- IDX — NUMBER
- MSG — VARCHAR2
WIGIS_MARKER
- ID — NUMBER — Primary key — NOT NULL
- USER_ID — NUMBER
- IP_ADDR — VARCHAR2
- CTIME — TIMESTAMP — NOT NULL
- MTIME — TIMESTAMP — NOT NULL
- NAME — NVARCHAR2
- FULL_NAME — NVARCHAR2
- ORGANELLE — NVARCHAR2
- KINGDOM — NVARCHAR2
- GENE_TYPE — NVARCHAR2
- PARENT_MARKER_ID — NUMBER — Foreign key → WIGIS_MARKER.ID
- MIG_GROUP_ID — NUMBER
- CATEGORY — VARCHAR2
- KTSN — NUMBER
- EMPID — VARCHAR2
- KTSN2 — NUMBER
WIGIS_MARKER_APPLYING_FIELD
- CODE — VARCHAR2 — Primary key — NOT NULL
- MARKER_ID — NUMBER — Foreign key → WIGIS_MARKER.ID — NOT NULL
WIGIS_MARKER_REFERENCES
- ID — NUMBER — Primary key — NOT NULL
- MARKER_ID — NUMBER — Foreign key → WIGIS_MARKER.ID — NOT NULL
- REFERENCE_ID — NUMBER — NOT NULL
WIGIS_MENU
- MENU_SEQ — NUMBER — NOT NULL
- MENU_NM — VARCHAR2
- URL — VARCHAR2
- PROG_ID — VARCHAR2
- ORDER_SEQ — NUMBER
- DEPTH_SEQ — NUMBER
- UPPER_MENU_SEQ — NUMBER
- USE_YN — CHAR
- REG_DT — DATE
- REG_ID — VARCHAR2
- MOD_DT — DATE
- MOD_ID — VARCHAR2
WIGIS_MENU_AUTH
- AUTH_GROUP_SEQ — NUMBER — NOT NULL
- MENU_SEQ — NUMBER — NOT NULL
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
WIGIS_MENU_AUTH_LINK
- AUTH_GROUP_SEQ — VARCHAR2 — NOT NULL
- MENU_SEQ — NUMBER — NOT NULL
- REG_DT — DATE
- REG_ID — VARCHAR2
- MOD_DT — DATE
- MOD_ID — VARCHAR2
WIGIS_MENU_DATA_AUTH
- CODE — VARCHAR2 — Primary key — NOT NULL
- MENU_SEQ — NUMBER — Primary key — NOT NULL
WIGIS_MI_EXPERIMENT
- MI_EXPERIMENT_ID — VARCHAR2 — Primary key — NOT NULL
- TITLE — VARCHAR2 — NOT NULL
- ALIAS — VARCHAR2
- SHORT_LABEL — VARCHAR2
- FULL_NM — VARCHAR2
- NCBI_TAXON_ID — VARCHAR2
WIGIS_MS_SEARCH
- KTSN — NUMBER — Primary key — NOT NULL
- MS_MARKER_NM_SET — VARCHAR2
- MS_DATASET_FILE — VARCHAR2
WIGIS_NOTICE_BOARD
- NOTICE_SEQ — NUMBER — Primary key — NOT NULL
- TITLE — VARCHAR2
- CONTENTS — VARCHAR2
- SELECT_CNT — NUMBER
- REG_DT — DATE
- REG_ID — NUMBER
- MOD_DT — DATE
- MOD_ID — NUMBER
- NOTICE_CLASS_CODE — VARCHAR2
- ATTACH_FILE_NM — VARCHAR2
- ATTACH_ORGIN_FILE_NM — VARCHAR2
- POST_YN — VARCHAR2
- POST_FROM_DATE — DATE
- POST_TO_DATE — DATE
WIGIS_ODS_CLASS
- ODS_CLASS_ID — VARCHAR2 — Primary key — NOT NULL
- NAME — VARCHAR2
- PARENT_ID — VARCHAR2
WIGIS_ODS_CONFIRM
- ODS_CONFIRM_ID — NUMBER — Primary key — NOT NULL
- REGISTRATOR_ID — VARCHAR2 — NOT NULL
- REG_DT — DATE — NOT NULL
- MOD_DT — DATE — NOT NULL
- HML_ATTACHMENT — VARCHAR2
- PDF_ATTACHMENT — VARCHAR2
- STATUS — VARCHAR2
- DENIED_REASON — VARCHAR2
WIGIS_ODS_KORD
- ODS_KORD_ID — NUMBER — Primary key — NOT NULL
- ODS_SPECIES_ID — NUMBER — Foreign key → WIGIS_ODS_SPECIES.ODS_SPECIES_ID — NOT NULL
- IDENTIFIER — VARCHAR2
- KORD_NM — VARCHAR2
- DATA — VARCHAR2
- WSDL_MSG_CD — VARCHAR2
- WSDL_MSG_NM — VARCHAR2
- WSDL_DT — DATE
- SEQ_LENGTH — NUMBER
WIGIS_ODS_SPECIES
- ODS_SPECIES_ID — NUMBER — Primary key — NOT NULL
- ODS_SUBMISSION_ID — NUMBER — Foreign key → WIGIS_ODS_SUBMISSION.ODS_SUBMISSION_ID — NOT NULL
- TAXON_ID — NUMBER
- ORGANISM — NVARCHAR2
- SAMPLE_NM — NVARCHAR2
- COLLECTION_ID — NVARCHAR2
- VOUCHER_ID — NVARCHAR2
- GR_ID — NVARCHAR2
- REGISTRATOR_ID — NUMBER — NOT NULL
- REG_DT — DATE — NOT NULL
- MOD_DT — DATE — NOT NULL
WIGIS_ODS_SUBMISSION
- ODS_SUBMISSION_ID — NUMBER — Primary key — NOT NULL
- IDENTIFIER — NVARCHAR2
- SAMPLE_NM — NVARCHAR2
- COLLECTION_ID — NVARCHAR2
- STATUS — NVARCHAR2
- CATEGORY — NVARCHAR2
- ORGANISM — NVARCHAR2
- TAXON_ID — NUMBER
- ODS_PROJECT_ID — NUMBER — NOT NULL
- REGISTRATOR_ID — NUMBER — NOT NULL
- VOUCHER_ID — NVARCHAR2
- PUBLISH_DT — DATE — NOT NULL
- REG_DT — DATE — NOT NULL
- MOD_DT — DATE — NOT NULL
- PDF_REG_DT — DATE
- META_ATTACHMENT — NVARCHAR2
- META_ATTACHMENT_SIZE — NUMBER
- META_ATTACHMENT_STATUS — NVARCHAR2
- RAW_ATTACHMENT — NVARCHAR2
- RAW_ATTACHMENT_SIZE — NUMBER
- RAW_ATTACHMENT_STATUS — NVARCHAR2
- DEL_YN — CHAR
- AREA — NVARCHAR2
- MAIN_CLASS — NVARCHAR2
- SUB_CLASS — NVARCHAR2
- GR_ID — NVARCHAR2
- PRE_ODS_SUBMISSION_ID — NUMBER
- APP_DT — DATE
- IS_OPEN — NVARCHAR2
WIGIS_ODS_SUBMISSIONSHARE
- ODS_SUBMISSION_SHARE_ID — NUMBER — Primary key — NOT NULL
- ODS_SUBMISSION_ID — NUMBER — NOT NULL
- SHARE_PERSON_ID — NUMBER — NOT NULL
- SHARE_STATUS — VARCHAR2
- REG_DT — DATE
- MOD_DT — DATE
WIGIS_ODS_SUBMISSION_CONFIRM
- ODS_SUBMISSION_CONFIRM_ID — NUMBER — Primary key — NOT NULL
- ODS_SUBMISSION_ID — NUMBER
- ODS_CONFIRM_ID — NUMBER
WIGIS_ORGANIZATION
- ID — NUMBER — Primary key — NOT NULL
- USER_ID — NUMBER — NOT NULL
- INTITUTION_ID — NUMBER
- AFFILIATION — NVARCHAR2
- AFFILIATION2 — NVARCHAR2
- POSITION — NVARCHAR2
- PI_NAME — NVARCHAR2
- COMMNET — NVARCHAR2
WIGIS_OSTD_BASIC
- OSTD_BASIC_ID — VARCHAR2 — Primary key — NOT NULL
- SOURCE — VARCHAR2
- CATEGORY — VARCHAR2
- TYPE — VARCHAR2
- TITLE — VARCHAR2
- PUB_DT — DATE
- PUB_YN — CHAR
- TAXON_ID — NUMBER — NOT NULL
- BIOENTRY_ID — NUMBER
- SRA_RUN_ID — VARCHAR2
- GEO_SERIES_ID — VARCHAR2 — Foreign key → WIGIS_GEO_SERIES.GEO_SERIES_ID
- MI_EXPERIMENT_ID — VARCHAR2 — Foreign key → WIGIS_MI_EXPERIMENT.MI_EXPERIMENT_ID
- PDB_ENTRY_ID — VARCHAR2
- STS_ENTRY_ID — VARCHAR2
- GBROWSER_URL — VARCHAR2
- FROM_OSTD_BASIC_ID — VARCHAR2
- KNAME — VARCHAR2
- VOUCHER_ID — NVARCHAR2
- GR_ID — NVARCHAR2
- COLLECTION_ID — NVARCHAR2
- USER_ID — NUMBER
- STATUS — NVARCHAR2
- PROTOCOL_METHOD — NCLOB
- PROJECT_ID — NUMBER
- ORIGIN_FILE — NVARCHAR2
- CTIME — DATE
- MTIME — DATE
- LOG_MESSAGE — NVARCHAR2
- IS_DEL — NVARCHAR2
- IP_ADDR — NVARCHAR2
- EVAL_STATUS — NVARCHAR2
- DESCRIPTION — NVARCHAR2
- APPLY_FIELD — NVARCHAR2
- ACCESSION — NVARCHAR2
- KTSN_TAXON_NAME — NVARCHAR2
- REJECT_MESSAGE — NVARCHAR2
- REJCT_REASON — NVARCHAR2
- MITO_VISUAL_IMG — VARCHAR2
- KTSN — NUMBER
- EMPID — VARCHAR2
- EVAL_STATUS_DT — TIMESTAMP
- MS_MARKER_NM — VARCHAR2
- REPEAT_MOTIF — VARCHAR2
- FORWARD_PRIMER_SEQ — VARCHAR2
- REVERSE_PRIMER_SEQ — VARCHAR2
- TMF — VARCHAR2
- TMR — VARCHAR2
- EXPEXTED_ALLELE_SIZE — VARCHAR2
- GENBANK_ACCESSION_NO — VARCHAR2
- FLUORESCENSE_LABEL — VARCHAR2
- SNP_MARKER_NM — VARCHAR2
- FIVE_PRIME — VARCHAR2
- THREE_PRIME — VARCHAR2
- SLICE_SEQ — VARCHAR2
- ALLELE_OBSERVATION — VARCHAR2
- ALLELE_POSITION — VARCHAR2
- ALLELE_FREQUENCY_RATE — VARCHAR2
- KTSN2 — NUMBER
- SUPPLY_DATA_FILE — VARCHAR2
WIGIS_OSTD_BASIC_HIST
- OSTD_BASIC_ID — VARCHAR2 — Primary key — NOT NULL
- HIST_VER — NUMBER — Primary key — NOT NULL
- SOURCE — VARCHAR2
- CATEGORY — VARCHAR2
- TYPE — VARCHAR2
- TITLE — VARCHAR2
- PUB_DT — DATE
- PUB_YN — CHAR
- TAXON_ID — NUMBER — NOT NULL
- BIOENTRY_ID — NUMBER
- SRA_RUN_ID — VARCHAR2
- GEO_SERIES_ID — VARCHAR2
- MI_EXPERIMENT_ID — VARCHAR2
- PDB_ENTRY_ID — VARCHAR2
- STS_ENTRY_ID — VARCHAR2
- GBROWSER_URL — VARCHAR2
- FROM_OSTD_BASIC_ID — VARCHAR2
- KNAME — VARCHAR2
- VOUCHER_ID — NVARCHAR2
- GR_ID — NVARCHAR2
- COLLECTION_ID — NVARCHAR2
- USER_ID — NUMBER
- STATUS — NVARCHAR2
- PROTOCOL_METHOD — NCLOB
- PROJECT_ID — NUMBER
- ORIGIN_FILE — NVARCHAR2
- CTIME — DATE
- MTIME — DATE
- LOG_MESSAGE — NVARCHAR2
- IS_DEL — NVARCHAR2
- IP_ADDR — NVARCHAR2
- EVAL_STATUS — NVARCHAR2
- DESCRIPTION — NVARCHAR2
- APPLY_FIELD — NVARCHAR2
- ACCESSION — NVARCHAR2
- KTSN_TAXON_NAME — NVARCHAR2
- REJECT_MESSAGE — NVARCHAR2
- REJCT_REASON — NVARCHAR2
- MITO_VISUAL_IMG — VARCHAR2
- KTSN — NUMBER
- EMPID — VARCHAR2
- EVAL_STATUS_DT — TIMESTAMP
- MS_MARKER_NM — VARCHAR2
- REPEAT_MOTIF — VARCHAR2
- FORWARD_PRIMER_SEQ — VARCHAR2
- REVERSE_PRIMER_SEQ — VARCHAR2
- TMF — VARCHAR2
- TMR — VARCHAR2
- EXPEXTED_ALLELE_SIZE — VARCHAR2
- GENBANK_ACCESSION_NO — VARCHAR2
- FLUORESCENSE_LABEL — VARCHAR2
- SNP_MARKER_NM — VARCHAR2
- FIVE_PRIME — VARCHAR2
- THREE_PRIME — VARCHAR2
- SLICE_SEQ — VARCHAR2
- ALLELE_OBSERVATION — VARCHAR2
- ALLELE_POSITION — VARCHAR2
- ALLELE_FREQUENCY_RATE — VARCHAR2
- KTSN2 — NUMBER
- SUPPLY_DATA_FILE — VARCHAR2
- … +1
WIGIS_OSTD_BASIC_MSA
- OSTD_BASIC_ID — VARCHAR2 — Foreign key → WIGIS_OSTD_BASIC.OSTD_BASIC_ID — NOT NULL
- OSTD_BASIC_MS_ID — VARCHAR2 — Foreign key → WIGIS_OSTD_BASIC.OSTD_BASIC_ID — NOT NULL
- ALLELE_SIZE — VARCHAR2
WIGIS_OSTD_BASIC_MSA_HIST
- OSTD_BASIC_ID — VARCHAR2 — Primary key — NOT NULL
- OSTD_BASIC_MS_ID — VARCHAR2 — Primary key — NOT NULL
- HIST_VER — NUMBER — Primary key — NOT NULL
- ALLELE_SIZE — VARCHAR2
and 95 more tables