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`