Example: SQL DDL

The SQL DDL that creates the Oracle tables for migration of the Footwear Orders sample MAPPER data report is shown below:

FootWearOrders_12D3954.sql

create sequence SEQ_FOOTWEAR_ORDER_LINEITEM start with 1000 increment by 1;

create table FOOTWEAR_ORDER_LINEITEM (
  FW_ORDER_LI_ID number(19,0) not null,
  ORDER_NO number(10,0) not null,
  QTY number(10,0) not null,
  SHOE_TYPE varchar2(5) not null,
  SHOE_GENDER varchar2(1) not null,
  SHOE_SIZE varchar2(4) not null,
  SHOE_COLOR varchar2(40),
  PRICE number(8,2) not null,
  ORDER_DATE_TIME date not null,
  COST number(8,2) null,
  CREATE_TIMESTAMP timestamp not null,
  DATE_OF_LAST_UPDATE timestamp not null,
  CREATED_BY_USER number(19,0) not null,
  UPDATE_USER_ID number(19,0) not null,
  PRIMARY KEY (FW_ORDER_LI_ID)
);

create table FOOTWEAR_ORDER_ADDRESSEE (
  FW_ORDER_LI_ID number(19,0) not null,
  ADDRESSEE varchar2(50) not null,
  STREET varchar2(80) not null,
  CITY_STATE_PROVINCE varchar2(60) not null,
  POSTAL_CODE varchar2(25) not null,
  EMAIL varchar2(60),
  PHONE varchar2(25),
  PRIMARY KEY (FW_ORDER_LI_ID)
);

create table MJ_FOOTWEAR_ORDER_LINEITEM (
  FW_ORDER_LI_ID number(19,0) not null,
  MJ_CABINET number(5,0),
  MJ_DRAWER char(1),
  MJ_REPORT number(5,0),
  MJ_LINENUM number(10,0),
  MJ_LINETYPE char(1),
  PRIMARY KEY (FW_ORDER_LI_ID)
);

previous

next