POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
CREATE TABLE LICENSE_RIGHT
(
APPLICATION_DATE | DATE | , |
AWARD_DATE | DATE | , |
DESCRIPTION | CHAR VARYING (2000) | , |
EFFECTIVE_DATE | DATE | , |
EXPIRY_DATE | DATE | , |
IDENTIFIER | CHAR VARYING (80) | NOT NULL, |
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) | , |
RENTAL_DUE_DATE | DATE | , |
R_LICENSE_RIGHT | CHAR VARYING (80) | REFERENCES R_LICENSE_RIGHT (IDENTIFIER), |
R_LICENSE_RIGHT_ACQUISITION | CHAR VARYING (80) | REFERENCES R_LICENSE_RIGHT_ACQUISITION (IDENTIFIER), |
SOURCE | CHAR VARYING (80) |