university

Tables (4)

ph_vacance_config

  • id — bigint — Primary key — NOT NULL
  • site_id — nvarchar(100)
  • descr — nvarchar(50)
  • vacance_year — int
  • begin_date — date
  • checkin_hour — nvarchar(10)
  • end_date — date
  • checkout_hour — nvarchar(10)
  • duration_day — int
  • duplicate_yn — nvarchar(1)
  • reserve_begin_date — datetime
  • reserve_end_date — datetime
  • use_yn — nvarchar(1)
  • del_yn — nvarchar(1)
  • reg_user_nm — nvarchar(64)
  • reg_user_id — nvarchar(32)
  • reg_date — datetime
  • mod_user_id — nvarchar(32)
  • mod_date — datetime
  • sites — nvarchar(100)

ph_vacance_member

  • id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → ph_vacance_room.id — NOT NULL
  • config_id — bigint — Foreign key → ph_vacance_room.config_id — NOT NULL
  • doctor_id — bigint
  • department_name — nvarchar(50)
  • member_name — nvarchar(50)
  • work_phone — nvarchar(14)
  • cell_phone — nvarchar(14)
  • home_phone — nvarchar(14)
  • member_email — nvarchar(50)
  • begin_date — date
  • checkin_hour — nvarchar(10)
  • end_date — date
  • checkout_hour — nvarchar(10)
  • people_count — int
  • transfered_yn — nvarchar(1)
  • transfered_id — bigint
  • use_yn — nvarchar(1)
  • del_yn — nvarchar(1)
  • reg_user_nm — varchar(64)
  • reg_user_id — nvarchar(32)
  • reg_date — date
  • mod_user_id — nvarchar(32)
  • mod_date — date

ph_vacance_room

  • id — bigint — Primary key — NOT NULL
  • config_id — bigint — Foreign key → ph_vacance_config.id — NOT NULL
  • room_type — nvarchar(10)
  • room_num — nvarchar(10)
  • room_name — nvarchar(50)
  • descr — nvarchar(200)
  • max_people — int
  • admin_yn — nvarchar(1)
  • use_yn — nvarchar(1)
  • del_yn — nvarchar(1)
  • reg_user_nm — nvarchar(64)
  • reg_user_id — nvarchar(32)
  • reg_date — datetime
  • mod_user_id — varchar(32)
  • mod_date — datetime

ph_vacance_room_date

  • id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → ph_vacance_room.id — NOT NULL
  • begin_date — date
  • end_date — date
  • use_yn — nvarchar(1)
  • reg_user_nm — nvarchar(64)
  • reg_user_id — nvarchar(32)
  • reg_date — datetime
  • mod_user_id — nvarchar(32)
  • mod_date — datetime