holidaykeeper
Tables (6)
County (지역)
- county_id (Key) — Primary key — NOT NULL
- code (Field)
- Field2
DeleteHolidayCandidate (삭제 후보 공휴일)
- deleteholiday_id (Key) — Primary key — NOT NULL
- holiyday_id (Key2) — Foreign key → holiday.holiyday_id — NOT NULL
HolidayCountry (공휴일_지역)
- Key — Primary key — NOT NULL
- holiyday_id (Key2) — Foreign key → holiday.holiyday_id — NOT NULL
- county_id (Key3) — Foreign key → County.county_id — NOT NULL
country (나라)
- country_id (Key) — Primary key — NOT NULL
- country_code (Field) — varchar(10)
- name (Field2) — varchar(100)
holiday (공휴일)
- holiyday_id (Key) — Primary key — NOT NULL
- country_id (Key2) — Foreign key → country.country_id — NOT NULL
- local_name (Field1) — varchar(100)
- name (Field3) — varchar(100)
- fixed (Field4) — boolean
- global (Field5) — boolean
- countries (Field6) — varchar(100)
- launch_year (Field7) — int
- types (Field8) — Enum(PUBLIC, BANK, SCHOOL ...)
- HolidayStatus (Field2) — Enum(ACTIVE, DELETE, ABOLIATION)