빅데응 팀플
테이블 (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