HOMES CREATE TABLE Script
Table - Sorted Table - Copybook - Create Table - Load File - Row Size - Back To Table Index

---
---   CREATE TABLE Script For HOMES Table
---   Created on: 23-MAY-2020 10:46 AM
---   Created by: +1Copybook (C)
---

CREATE TABLE HOMES (
HOMES_KEY                          	BIGINT,
HOMES_GRPCD                        	SMALLINT,
HOME_A_NUMBER                      	SMALLINT,
HOME_B_KEY                         	SMALLINT,
HOME_A_CHANGE_FLAG                 	VARCHAR(1),
HOME_A_SITE_FLAG                   	VARCHAR(1),
HOME_A_SITE_VALUE_CODER            	VARCHAR(4),
HOME_A_SITE_VALUE                  	INT,
HOME_A_CURR_VALUE                  	INT,
HOME_A_XFEA_VALUE                  	INT,
HOME_A_TOTAL_SQFTG                 	INT,
HOME_A_BEDROOMS                    	INT,
HOME_A_BATHS                       	INT,
HOME_A_HALF_BATHS                  	INT,
HOME_A_UNITS                       	INT,
HOME_A_FLOORS                      	SMALLINT,
HOME_B_CHANGE_FLAG                 	VARCHAR(1),
HOME_B_CODE                        	VARCHAR(1),
HOME_B_ADD_SQFTG_FLAG              	VARCHAR(1),
HOME_B_VALUE                       	INT,
HOME_B_ITEMS                       	DECIMAL(6,2),
HOME_B_SPECIAL                     	DECIMAL(8,3),
HOME_B_TOTAL_SQFTG                 	INT,
HOME_B_PTS_GRADE                   	SMALLINT,
HOME_B_GRADE                       	SMALLINT,
HOME_B_ADDITION                    	VARCHAR(10),
HOMES_X_DISTRICT                   	SMALLINT,
HOME_B_NC_FLAG                     	VARCHAR(1),
HOME_B_NC_NEW                      	INT,
HOME_B_NC_ADD                      	INT,
HOME_B_NC_DEMO                     	INT,
HOME_B_REAPPRAISAL                 	INT
)
/


To Top - Print - copybook.txt

Output Generated By +1Copybook From +1 Software Engineering LLC.
Created on: 23-MAY-2020 10:46 AM