에버킥_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