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