create database olap_dwd;
use olap_dwd;
create table dwd_users(
    id varchar(100) not null primary key,
    name varchar(100) not null default '',
    authenticated_status smallint(2),
    birthdate date,
    checked_status smallint(2),
    third_party_loginNo varchar(255),
    created_time datetime,
    email varchar(50),
    head_photo varchar(255),
    one_inch_color_white_photo varchar(500),
    telephone  varchar(50),
    last_appeal_status  tinyint(2),
    id_card_num varchar(100),
    security_certificate_no varchar(1000),
    education varchar(100),
    stature varchar(50),
    nation varchar(100),
    politics_status varchar(100),
    household_type varchar(100),
    marital_status varchar(100),
    military_status varchar(100),
    front_photo varchar(500),
    reverse_photo varchar(500),
    background_screening_status smallint(2),
    cid varchar(200),
    last_sync_time datetime,
    last_cer_sync_time datetime
);

create table dwd_employees(
  id varchar(100) not null primary key,
  status smallint(2) not null default 0,
  hired_date datetime,
  leave_time datetime,
  is_domain_admin int,
  occupation_type smallint(2),
  tenant_user_id varchar(100) not null,
  industry_code varchar(255),
  institutional_code varchar(255),
  depart_id varchar(255),
  depart_name varchar(255),
  org_id varchar(50) not null,
  org_name varchar(50) not null default '', 
  org_supervise_region_code varchar(255),
  org_supervise_depart_id varchar(255),
  org_supervise_depart_name varchar(255),
  last_org_sync_time datetime,
  last_sync_time datetime
);

create index index_dwd_employees_org_id on dwd_employees(org_id)