RdsDiagram
BOOKS
BOOK_ID: INTEGER
BOOK_NAME: VARCHAR(128)
BOOK_GENRE: VARCHAR(128)
BOOK_IS_AVAILABLE: BOOLEAN
BOOK_MIN_SUBSCRIPTION_LVL: INTEGER
AUTHOR_ID: INTEGER
LIBRARY_ID: INTEGER
AUTHORS
AUTHOR_ID: INTEGER
AUTHOR_NAME: VARCHAR(128)
AUTHOR_COUNTRY: VARCHAR(128)
LIBRARIES
LIBRARY_ID: INTEGER
LIBRARY_NAME: VARCHAR(128)
LIBRARY_IS_OPEN: BOOLEAN
LOCATION_ID: INTEGER
USERS
USER_ID: INTEGER
LOCATION_ID: INTEGER
USER_NAME: VARCHAR(128)
USER_CATEGORY: VARCHAR(128)
SUBSCRIPTION_LVL: INTEGER
RECORD_LOG
RECORD_ID: INTEGER
RECORD_IS_CLOSED: BOOLEAN
RECORD_START_DATE: TIMESTAMP
RECORD_EXP_DATE: TIMESTAMP
BOOK_ID: INTEGER
USER_ID: INTEGER
SUBSCRIPTIONS
SUBSCRIPTION_LVL: INTEGER
SUBSCRIPTION_FEE: INTEGER
SUBSCRIPTION_LOG
USER_ID: INTEGER
SUBSCRIPTION_ID: INTEGER
SUBSCRIPTION_LVL: INTEGER
SUBSCRIPTION_START: TIMESTAMP
SUBSCRIPTION_IS_ACTIVE: BOOLEAN
SUBSCRIPTION_END: TIMESTAMP
LOCATION
LOCATION_ID: INTEGER
COUNTRY: VARCHAR(128)
REGION: VARCHAR(128)
CITY: VARCHAR(128)