DB_과제

테이블 (10)

CREATE_TASK

  • MEMBER_id — VARCHAR(20) — 외래 키 → MEMBER.id — NOT NULL
  • TASK_id — INT — 외래 키 → TASK.id — NOT NULL
  • INDEX — `fk_CREATE_TASK_MEMBER1_idx`
  • INDEX — `fk_CREATE_TASK_TASK1_idx`

ESTIMINATE

  • isPass — TINYINT
  • grade — INT
  • MEMBER_id — VARCHAR(20) — 외래 키 → MEMBER.id — NOT NULL
  • PARSE_SEQ_DATA_FILE_id — INT — 외래 키 → PARSE_SEQ_DATA_FILE.id — NOT NULL
  • INDEX — `fk_ESTIMINATE_MEMBER1_idx`
  • INDEX — `fk_ESTIMINATE_PARSE_SEQ_DATA_FILE1_idx`

JOIN_TASK

  • MEMBER_id — VARCHAR(20) — 외래 키 → MEMBER.id — NOT NULL
  • TASK_id — INT — 외래 키 → TASK.id — NOT NULL
  • INDEX — `fk_JOIN_TASK_MEMBER1_idx`
  • INDEX — `fk_JOIN_TASK_TASK1_idx`

MEMBER

  • id — VARCHAR(20) — 기본 키 — NOT NULL
  • pw — VARCHAR(45) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • gender — VARCHAR(2) — NOT NULL
  • address — VARCHAR(100) — NOT NULL
  • phone — INT — NOT NULL
  • Bday — DATE — NOT NULL
  • grade — INT
  • isAdmin — TINYINT
  • isEst — TINYINT
  • isSub — TINYINT

ORIG_METADATA

  • orig_id — INT — 기본 키 — NOT NULL
  • TASK_id — INT — 외래 키 → TASK.id — NOT NULL
  • data_type — VARCHAR(45) — NOT NULL
  • INDEX — `fk_ORIG_METADATA_TASK1_idx`

PARSE_SEQ_DATA_FILE

  • id — INT — 기본 키 — NOT NULL
  • times — INT — NOT NULL
  • period — INT — NOT NULL
  • size — INT — NOT NULL
  • dup_ratio — REAL — NOT NULL
  • null_ratio — REAL — NOT NULL
  • TASK_id — INT — 외래 키 → TASK.id — NOT NULL
  • INDEX — `fk_PARSE_SEQ_DATA_FILE_TASK1_idx`

SEQ_METADATA

  • id — INT — 기본 키 — NOT NULL
  • TASK_id — INT — 외래 키 → TASK.id — NOT NULL
  • data_type — VARCHAR(45) — NOT NULL
  • INDEX — `fk_SEQ_METADATA_TASK_idx`

SUBMIT_DATA

  • MEMBER_id — VARCHAR(20) — 외래 키 → MEMBER.id — NOT NULL
  • PARSE_SEQ_DATA_FILE_id — INT — 외래 키 → PARSE_SEQ_DATA_FILE.id — NOT NULL
  • INDEX — `fk_SUBMIT_DATA_MEMBER1_idx`
  • INDEX — `fk_SUBMIT_DATA_PARSE_SEQ_DATA_FILE1_idx`

TASK

  • id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(45)
  • manual — VARCHAR(1000)
  • period — VARCHAR(45)

TASK_DATA_TABLE

  • PARSE_SEQ_DATA_FILE_id — INT — 외래 키 → PARSE_SEQ_DATA_FILE.id — NOT NULL
  • SEQ_METADATA_id — INT — 외래 키 → SEQ_METADATA.id — NOT NULL
  • INDEX — `fk_TASK_DATA_TABLE_PARSE_SEQ_DATA_FILE1_idx`
  • INDEX — `fk_TASK_DATA_TABLE_SEQ_METADATA1_idx`