☰
LG
Liaison
Management Portal
Database active
Row Density
Compact
Edit
duty_visit_plan_version
Typed form generated from live table metadata, now with inline smart FK resolution.
Back to List
id
pk
type=uuid, required
duty_visit_id
duty_visit
FK
⌄
type=uuid, required
version_type
enum: PLAN | CONFIRM
PLAN
CONFIRM
type=plan_version_type_enum, required
start_datetime
type=timestamptz, nullable
end_datetime
type=timestamptz, nullable
host_country_id
country
FK
⌄
type=uuid, nullable
host_province_id
province
FK
⌄
type=uuid, nullable
host_city_id
city
FK
⌄
type=uuid, nullable
planned_headcount
type=int4, required
purpose
type=text, nullable
notes
type=text, nullable
created_at
type=timestamptz, required
updated_at
type=timestamptz, required
visit_location
type=text, nullable
planned_date_mode
type=varchar, required
planned_year
type=int4, nullable
planned_month
type=int4, nullable
planned_quarter
type=int4, nullable
location_to_be_confirmed
NULL
true
false
type=bool, required
host_continent_id
continent
FK
⌄
type=uuid, nullable
Save
Cancel