에버킥_v1

테이블 (12)

attachmentfile

  • file_idx — INTEGER — 기본 키 — NOT NULL
  • file_name — VARCHAR2(50)
  • file_real_name — VARCHAR2(50)
  • file_path — VARCHAR2(50)
  • file_comment — VARCHAR2(50)

children_info

  • children_idx — INTEGER — 기본 키 — NOT NULL
  • guardian_idx — INTEGER — 외래 키 → guardian_info.guardian_idx — NOT NULL
  • children_name — VARCHAR2(50)
  • children_birth — VARCHAR2(10)
  • children_height — VARCHAR2(10)
  • children_weight — VARCHAR2(10)

club_team

  • team_idx — INTEGER — 기본 키 — NOT NULL
  • team_id — VARCHAR2(200)
  • team_password — VARCHAR2(255)
  • team_name — VARCHAR2(50)
  • code_idx — CHAR(4) — NOT NULL
  • emblem_file — INTEGER — NOT NULL
  • supervision_name — VARCHAR2(20)
  • supervision_phone — VARCHAR2(13)
  • coach_name — VARCHAR2(20)
  • coach_phone — VARCHAR2(13)
  • team_mail — VARCHAR2(100)

code

  • code_idx — CHAR(4) — 기본 키 — NOT NULL
  • up_code — CHAR(4)
  • code_korean — VARCHAR2(50)
  • code_english — VARCHAR2(50)

competition

  • competition_idx — INTEGER — 기본 키 — NOT NULL
  • file_idx — INTEGER — 외래 키 → attachmentfile.file_idx — NOT NULL
  • competition_name — VARCHAR2(100)
  • competition_date — VARCHAR(50)
  • min_join_club — INTEGER
  • competition_comment — TEXT
  • standard_class — VARCHAR2(50)

guardian_info

  • guardian_idx — INTEGER — 기본 키 — NOT NULL
  • team_idx — INTEGER — NOT NULL
  • guardian_name — VARCHAR2(50)
  • guardian_id — VARCHAR2(200)
  • guardian_password — VARCHAR2(10)
  • guardian_mail — VARCHAR2(100)

join_club_team

  • team_idx — INTEGER — 기본 키 — NOT NULL
  • competition_idx — INTEGER — 외래 키 → competition.competition_idx — NOT NULL
  • file_idx — INTEGER — 외래 키 → competition.file_idx — NOT NULL
  • team_name — VARCHAR2(50)
  • code_idx — CHAR(4) — NOT NULL
  • emblem_file — INTEGER — NOT NULL
  • supervision_name — VARCHAR2(20)
  • supervision_phone — VARCHAR2(13)
  • coach_name — VARCHAR2(20)
  • coach_phone — VARCHAR2(13)
  • team_mail — VARCHAR2(100)
  • join_class — VARCHAR2(50)
  • paid_service_yn — CHAR(1)

join_team_player

  • player_idx — INTEGER — 기본 키 — NOT NULL
  • team_idx — INTEGER — 외래 키 → join_club_team.team_idx — NOT NULL
  • competition_idx — INTEGER — 외래 키 → join_club_team.competition_idx — NOT NULL
  • file_idx — INTEGER — 외래 키 → join_club_team.file_idx — NOT NULL
  • team_version — VARCHAR2(20)
  • player_name — VARCHAR2(50)
  • player_school — VARCHAR2(50)
  • player_birth — VARCHAR2(10)
  • player_type — CHAR(4) — NOT NULL

lesson_teacher

  • lesson_idx — INTEGER — 기본 키 — NOT NULL
  • lesson_name — VARCHAR2(50)
  • lesson_id — VARCHAR2(200)
  • lesson_password — VARCHAR2(10)
  • lesson_mail — VARCHAR2(100)
  • lesson_phone — VARCHAR2(13)
  • elementary_school — VARCHAR2(100)
  • middle_school — VARCHAR2(100)
  • high_school — VARCHAR2(100)
  • university — VARCHAR2(100)
  • etc — TEXT
  • lesson_type — VARCHAR2(200)
  • lesson_type_etc — VARCHAR2(200)

personal_history

  • personal_idx — INTEGER — 기본 키 — NOT NULL
  • lesson_idx — INTEGER — 외래 키 → lesson_teacher.lesson_idx — NOT NULL
  • personal_name — VARCHAR2(100)
  • personal_start_date — VARCHAR2(7)
  • personal_end_date — VARCHAR2(7)

qualifications

  • qualifications_idx — INTEGER — 기본 키 — NOT NULL
  • lesson_idx — INTEGER — 외래 키 → lesson_teacher.lesson_idx — NOT NULL
  • qualifications_file_idx — INTEGER — 외래 키 → attachmentfile.file_idx — NOT NULL
  • qualifications_name — VARCHAR2(100)
  • qualifications_date — VARCHAR2(100)
  • certification_yn — CHAR(1)

team_player

  • player_idx — INTEGER — 기본 키 — NOT NULL
  • team_idx — INTEGER — 외래 키 → club_team.team_idx — NOT NULL
  • team_version — VARCHAR2(20)
  • player_name — VARCHAR2(50)
  • player_school — VARCHAR2(50)
  • player_birth — VARCHAR2(10)
  • player_type — CHAR(4) — NOT NULL