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

Untitled

    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)