빅데응 팀플

테이블 (13)

7월 성별 (gender_July)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint

7월 연령 (age_July)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • under_twenty — bigint
  • under_thirty — bigint
  • under_fourty — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint

8월 성별 (gender_August)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint

8월 연령 (age_August)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • under_twenty — bigint
  • under_thirty — bigint
  • under_fourty — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint

9월 성별 (gender_September)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint

9월 연령 (age_september)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • under_twenty — bigint
  • under_thirty — bigint
  • under_fourty — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint

review

  • personnal code (id) — int — 기본 키 — NOT NULL
  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • Field (comment) — varchar(500)
  • Field

total passenger (total_passenger)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • July — bigint — NOT NULL
  • August — bigint — NOT NULL
  • September — bigint — NOT NULL
  • July_attendant — bigint
  • August_attendant — bigint
  • September_attendant — bigint

국가 (country)

  • country_name — varchar(50) — 기본 키 — NOT NULL
  • 이름 (continent_name) — varchar(10) — 외래 키 → 대륙.대륙 이름 — NOT NULL

대륙 (continent)

  • 대륙 이름 (continent_name) — varchar(10) — 기본 키 — NOT NULL

전년7월대비성장률(YearOnYear) (growth_July)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint
  • under_twenty — bigint
  • under_thirty — bigint
  • under_forty (under_fourty) — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint

전년8월성장률 (growth_august)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint
  • under_twenty — bigint
  • under_thirty — bigint
  • under_forty (under_fourty) — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint

전년9월대비성장률 (growth_september)

  • country_name — varchar(50) — 외래 키 → 국가.country_name — NOT NULL
  • male — bigint
  • female — bigint
  • under_twenty — bigint
  • under_thirty — bigint
  • under_forty (under_fourty) — bigint
  • under_fifty — bigint
  • under_sixty — bigint
  • over_sixty — bigint