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