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 — 사진