☰
LG
Liaison
Management Portal
Database active
Row Density
Compact
Create
duty_visit
Typed form generated from live table metadata, now with inline smart FK resolution.
Back to List
id
pk
type=uuid, required
visit_code
type=varchar, required
title_en
type=varchar, nullable
title_zh
type=varchar, nullable
report_required
NULL
true
false
type=bool, required
report_due_date
type=date, nullable
report_submitted_date
type=date, nullable
report_completed
NULL
true
false
type=bool, required
presentation_required
NULL
true
false
type=bool, required
presentation_due_date
type=date, nullable
presentation_completed_date
type=date, nullable
presentation_completed
NULL
true
false
type=bool, required
remarks
type=text, nullable
created_at
type=timestamptz, required
updated_at
type=timestamptz, required
visit_category_code
visit_category
FK
⌄
type=varchar, required
main_category_code
main_category
FK
⌄
type=varchar, required
visit_direction_code
visit_direction
FK
⌄
type=varchar, required
status_code
visit_status
FK
⌄
type=varchar, required
fiscal_year_code
fiscal_year
FK
⌄
type=varchar, required
event_series_code
event_series
FK
⌄
type=varchar, nullable
stream
enum: FIRE | AMB
NULL
FIRE
AMB
type=duty_visit_stream_enum, nullable
budget_annual_amount
type=numeric, nullable
estimation_before_departure_amount
type=numeric, nullable
actual_completion_amount
type=numeric, nullable
budget_annual_calc
type=jsonb, nullable
estimation_before_departure_calc
type=jsonb, nullable
actual_completion_calc
type=jsonb, nullable
actual_expenditure_items
type=jsonb, nullable
budget_vote_code
type=varchar, nullable
Create
Cancel