photofile
Tables (4)
answer_table
- 아이디 — VARCHAR2(100 ) — NOT NULL
- 이름 — VARCHAR2(100 ) — NOT NULL — 이름
- 소속팀 — INTEGER — NOT NULL — 소속팀
- 시작일 — DATE — NOT NULL — 시작일
pair_employee
- employee_id — VARCHAR2(20 ) — Primary key — NOT NULL
- employee_name — VARCHAR2(50 ) — NOT NULL — 개발자
- employee_email — VARCHAR2(50 ) — NOT NULL — 개발자
- employee_team — INTEGER — NOT NULL — 개발자
pair_teamhistory
- teamhistory_seq — INTEGER — Primary key — NOT NULL
- employee_id — VARCHAR2(20 ) — Foreign key → pair_employee.employee_id — NOT NULL — 개발자
- teamhistory_team — INTEGER — NOT NULL — 변경된
- teamhistory_startdate — DATE — NOT NULL — 팀변경
- teamhistory_enddate — DATE — NOT NULL — 해당팀
- employee_type — VARCHAR2(10 ) — NOT NULL — 진행자(Driver)
photo_file
- album_seq — INTEGER — NOT NULL — 앨범
- album_title — VARCHAR2(100) — NOT NULL — 사진
- album_location — VARCHAR2(100) — NOT NULL — 사진
- album_date — TIMESTAMP — NOT NULL — 사진