AREA_CODE | CHAR VARYING (10) | , |
BUSINESS_ASSOCIATE_S | CHAR VARYING (19) | REFERENCES BUSINESS_ASSOCIATE (INSTANCE_S), |
COUNTRY_CODE | CHAR VARYING (10) | , |
DATA_VALUE | CHAR VARYING (80) | , |
DESCRIPTION | CHAR VARYING (2000) | , |
EFFECTIVE_DATE | DATE | , |
ENTITY_TYPE_NM | CHAR VARYING (30) | NOT NULL CHECK (ENTITY_TYPE_NM IN ('EMAIL_ADDRESS', 'MAILING_ADDRESS', 'PHONE_NUMBER', 'PHYSICAL_ADDRESS', 'WWW_ADDRESS')), |
EXPIRY_DATE | DATE | , |
EXTENSION_CODE | CHAR VARYING (10) | , |
FACILITY_S | CHAR VARYING (19) | , |
FACILITY_T | CHAR VARYING (30) | , |
INSTANCE_CREATE_DATE | TIMESTAMP | , |
INSTANCE_CREATOR | CHAR VARYING (80) | , |
INSTANCE_S | CHAR VARYING (19) | NOT NULL PRIMARY KEY, |
LAST_UPDATED | TIMESTAMP | , |
LAST_UPDATED_BY | CHAR VARYING (80) | , |
LINE_1 | CHAR VARYING (40) | , |
LINE_2 | CHAR VARYING (40) | , |
LINE_3 | CHAR VARYING (40) | , |
LOCAL_PHONE_NUMBER | CHAR VARYING (10) | , |
PHYSICAL_ADDRESS_S | CHAR VARYING (19) | REFERENCES ADDRESS (INSTANCE_S), |
POSTAL_CODE_S | CHAR VARYING (19) | REFERENCES R_POSTAL_CODE (INSTANCE_S), |
ROOM_NUMBER | CHAR VARYING (40) | , |
R_ADDRESS_QUALIFIER | CHAR VARYING (80) | REFERENCES R_ADDRESS_QUALIFIER (IDENTIFIER), |
SOURCE | CHAR VARYING (80) | , |
STREET_NAME | CHAR VARYING (40) | , |
STREET_NUMBER | CHAR VARYING (40) | , |
STREET_SUFFIX | CHAR VARYING (40) | , |
URL | CHAR VARYING (255) | |
)