13 lines
629 B
SQL
13 lines
629 B
SQL
ALTER TABLE public.ak_users
|
|
ADD COLUMN IF NOT EXISTS health_goal text,
|
|
ADD COLUMN IF NOT EXISTS service_address text,
|
|
ADD COLUMN IF NOT EXISTS emergency_contact text,
|
|
ADD COLUMN IF NOT EXISTS chronic_notes text,
|
|
ADD COLUMN IF NOT EXISTS care_preference text;
|
|
|
|
COMMENT ON COLUMN public.ak_users.health_goal IS '健康目标';
|
|
COMMENT ON COLUMN public.ak_users.service_address IS '常住服务地址';
|
|
COMMENT ON COLUMN public.ak_users.emergency_contact IS '紧急联系人';
|
|
COMMENT ON COLUMN public.ak_users.chronic_notes IS '慢病或过敏备注';
|
|
COMMENT ON COLUMN public.ak_users.care_preference IS '护理偏好';
|