1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
| CREATE TABLE omo.consultant (
| id serial4 NOT NULL,
| agent_no varchar NOT NULL,
| "name" varchar NULL,
| photo_path varchar NULL,
| expertise varchar NULL,
| avg_score float4 NULL,
| title varchar NULL,
| "role" varchar NULL,
| created_date timestamp NULL,
| created_by varchar NULL,
| last_modified_date timestamp NULL,
| last_modified_by varchar NULL,
| serve_area varchar NULL,
| gender varchar NULL,
| phone_number varchar NULL,
| company_address varchar NULL,
| latest_login_time timestamp NULL,
| seniority varchar NULL,
| concept varchar NULL,
| experience varchar NULL,
| award varchar NULL,
| recommend bool NULL,
| CONSTRAINT consultant_pkey PRIMARY KEY (id)
| );
|
|
