· 4 years ago · Apr 05, 2021, 06:42 AM
1-- Tambahkan ts_query untuk nama developer
2create table if not exists master.temp_developer
3(
4 id varchar(64) not null
5 constraint developer_pk
6 primary key,
7 name varchar(64) not null,
8 address varchar not null,
9 logo varchar(500) not null,
10 description text,
11 is_deleted boolean default false not null,
12 created_date timestamp(0) not null,
13 created_by varchar(64) not null,
14 updated_by varchar(64),
15 updated_date timestamp(0),
16 deleted_date timestamp(0),
17 deleted_by varchar(64),
18 active boolean default false not null,
19 company_name varchar(64)
20);
21