Visa
Tables (6)
ph_visa (비자검진 테이블)
- VISA_ID — int — Primary key — NOT NULL
- VISA_TYPE_CODE — varchar(32) — Foreign key → ph_visa_type.CODE — NOT NULL
ph_visa_applier (비자 검진자 테이블)
- APPLIER_ID (검진자ID) — Int — Primary key — NOT NULL
- VISA_ID — int — Foreign key → ph_visa.VISA_ID — NOT NULL
- RES_DAY_ID — int — Foreign key → ph_visa_schedule_day.DAY_ID — NOT NULL
ph_visa_schedule (비자검진 일정 테이블)
- SCHEDULE_ID — int — Primary key — NOT NULL
- BGNDT — date
- ENDDT — date
ph_visa_schedule_day (비자검진 일정 날짜 테이블)
- DAY_ID — int — Primary key — NOT NULL
- WEEK_DAY — varchar(1)
- CNT — int
- SCHEDULE_ID — int — Foreign key → ph_visa_schedule.SCHEDULE_ID — NOT NULL
ph_visa_schedule_type_code (비자검진 종류 일정 테이블)
- SCHEDULE_ID — int — Foreign key → ph_visa_schedule.SCHEDULE_ID — NOT NULL
- VISA_TYPE_CODE — varchar(32)
ph_visa_type (비자 검진 종류 테이블)
- VISA_TYPE_ID — int — Primary key — NOT NULL
- CODE — varchar(32) — Primary key — NOT NULL