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