JumpRopeChecker
Tables (7)
cmptAttend (대회참가)
- Key (cmpt_attend_id) — Long — Primary key — NOT NULL
- Key (organization_id) — Long — Foreign key → organization.Key — NOT NULL
- Key (competition_id) — Long — Foreign key → competition.Key — NOT NULL
- Key (depart_id) — Long — Foreign key → department.Key — NOT NULL
- Field (player_name) — varchar
- Field2 (player_gender) — boolean
- Field3 (player_age) — timestamp
- Field4 (player_tel) — varchar
- Field (player_affiliation) — varchar
competition (대회)
- Key (competition_id) — Long — Primary key — NOT NULL
- Field (competition_name) — varchar
- Field (competition_host) — varchar
- Field (host_email) — varchar
- Field (host_tel) — varchar
- Field (competition_start_date) — timestamp
- Field (competition_end_date) — timestamp
competitionEvent (대회종목)
- Key (competition_event_id) — Long — Primary key — NOT NULL
- Key (competition_id) — Long — Foreign key → competition.Key — NOT NULL
- Key (event_id) — Long — Foreign key → event.Key — NOT NULL
- Field (is_proceed) — boolean
- Field (part_point) — int
- Field (fst_prize_standard) — int
- Field (snd_prize_standard) — int
- Field (trd_prize_standard) — int
- Field (kinder_fst_standard) — int
- Field3 (kinder_snd_standard) — int
- Field4 (kinder_trd_standard) — int
- Field5 (e1_fst_standard) — int
- Field6 (e1_snd_standard) — int
- Field7 (e1_trd_standard) — int
- Field8 (e2_fst_standard) — int
- Field9 (e2_snd_standard) — int
- Field10 (e2_trd_standard) — int
- Field11 (e3_fst_standard) — int
- Field12 (e3_snd_standard) — int
- Field13 (e3_trd_standard) — int
- Field14 (e4_fst_standard) — int
- Field15 (e4_snd_standard) — int
- Field16 (e4_trd_standard) — int
- Field17 (e5_fst_standard) — int
- Field18 (e5_snd_standard) — int
- Field (e5_trd_standard) — int
- Field3 (e6_fst_standard) — int
- Field4 (e6_snd_standard) — int
- Field19 (e6_trd_standard) — int
- Field (mh_fst_standard) — int
- Field21 (mh_snd_standard) — int
- Field22 (mh_trd_standard) — int
- Field23 (cm_fst_standard) — int
- Field24 (cm_snd_standard) — int
- Field25 (cm_trd_standard) — int
department (부서)
- Key (depart_id) — Long — Primary key — NOT NULL
- Field (depart_name) — varchar
event (종목)
- Key (event_id) — Long — Primary key — NOT NULL
- Field (event_name) — varchar
- Field (is_group) — Boolean
eventAttend (종목참가)
- Key (event_attend_id) — Long — Primary key — NOT NULL
- Key (competition_event_id) — Long — Foreign key → competitionEvent.Key — NOT NULL
- Key (cmpt_attend_id) — Long — Foreign key → cmptAttend.Key — NOT NULL
- Key (competition_id) — Long — Foreign key → cmptAttend.Key — NOT NULL
- Field (score) — int
- Field (grade) — int
organization (단체)
- Key (organization_id) — Long — Primary key — NOT NULL
- Field (organization_name) — varchar
- Field (organization_leader) — varchar
- Field (organization_email) — varchar
- Field (organization_tel) — varchar
- Field (leader_tel) — varchar