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