pcalife/PAM.git - dev.pollex.com.tw

¤ñ¹ï·sÀÉ®×
			@@ -0,0 +1,42 @@
			-- æ°å¢é ç´å®éç¥æ·ç¨table

			CREATE TABLE public.appointment_notice_log (
			id bigserial NOT NULL,
			appointment_id bigserial NOT NULL,
			email varchar NULL,
			phone varchar NULL,
			"content" varchar NULL,
			created_date timestamp NULL,
			CONSTRAINT appointment_notice_log_pkey PRIMARY KEY (id)
			);


			-- æ°å¢é ç´å®åè¨»table

			CREATE TABLE public.appointment_memo (
			id bigserial NOT NULL,
			"content" varchar NOT NULL,
			appointment_id int8 NOT NULL,
			created_date timestamp NOT NULL,
			created_by varchar NOT NULL,
			last_modified_date timestamp NOT NULL,
			last_modified_by varchar NOT NULL,
			CONSTRAINT appointment_memo_pkey PRIMARY KEY (id)
			);


			-- æ°å¢ç´è¨ªç´étable

			CREATE TABLE public.interview_record (
			id bigserial NOT NULL,
			created_date timestamp NOT NULL,
			created_by varchar NOT NULL,
			last_modified_date timestamp NOT NULL,
			last_modified_by varchar NOT NULL,
			"content" varchar NULL,
			interview_date timestamp NULL,
			appointment_id bigserial NOT NULL,
			status varchar NULL,
			CONSTRAINT interview_record_pkey PRIMARY KEY (id)
			);