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