Passport

Tables (3)

Country (Untitled2)

  • country_id (id) — bigint — Primary key — NOT NULL
  • 국가코드 (code) — varchar(255) — NOT NULL
  • 국가이름 (name) — varchar(255) — NOT NULL

Passport (Untitled)

  • passport_id (id) — bigint — Primary key — NOT NULL
  • 국가DB번호 (country_id) — bigint — Foreign key → Country.country_id — NOT NULL
  • 여권번호 (passportNo) — varchar(255) — NOT NULL
  • 이름 (fullName) — varchar(255) — NOT NULL
  • 생년월일 (birthDate) — LocalDate — NOT NULL
  • 발행일자 (issueDate) — LocalDate — NOT NULL
  • 만료일자 (expiryDate) — LocalDate — NOT NULL

Visa (Untitled3)

  • visa_id (id) — bigint — Primary key — NOT NULL
  • 여권DB번호 (passport_id) — bigint — Foreign key → Passport.passport_id — NOT NULL
  • 국가DB번호 (country_id) — bigint — Foreign key → Country.country_id — NOT NULL
  • 발행날짜 (startDate) — LocalDate — NOT NULL
  • 만료일자 (endDate) — LocalDate — NOT NULL