epro2
Tables (19)
BADGES
- ID — NUMBER(19) — Primary key — NOT NULL
- CODE — VARCHAR2(50) — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- DESCRIPTION — VARCHAR2(255)
- ICON_URL — VARCHAR2(500)
- CONDITION_TYPE — VARCHAR2(50)
- THRESHOLD_VALUE — NUMBER(12,2)
- CREATED_AT — TIMESTAMP — NOT NULL
CLASSIFICATION_REQUESTS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- CLOTHING_ITEM_ID — NUMBER(19)
- IMAGE_URL — VARCHAR2(500) — NOT NULL
- STATUS — VARCHAR2(20)
- PREDICTED_GRADE — VARCHAR2(20)
- PREDICTED_MATERIAL — VARCHAR2(50)
- PREDICTED_CATEGORY — VARCHAR2(50)
- PROCESSED_AT — TIMESTAMP
- CREATED_AT — TIMESTAMP — NOT NULL
CLOTHING_FAVORITES
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- CLOTHING_ITEM_ID — NUMBER(19) — NOT NULL
- CREATED_AT — TIMESTAMP — NOT NULL
CLOTHING_IMAGES
- ID — NUMBER(19) — Primary key — NOT NULL
- CLOTHING_ITEM_ID — NUMBER(19) — NOT NULL
- IMAGE_URL — VARCHAR2(500) — NOT NULL
- IS_MAIN — CHAR(1)
- CREATED_AT — TIMESTAMP — NOT NULL
CLOTHING_ITEMS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- NAME — VARCHAR2(255)
- CATEGORY — VARCHAR2(50)
- BRAND — VARCHAR2(100)
- SIZE — VARCHAR2(20)
- COLOR — VARCHAR2(50)
- PREFERENCE — NUMBER(10)
- DETAIL_DESC — VARCHAR2(1000)
- MATERIAL — VARCHAR2(50)
- CONDITION_GRADE — VARCHAR2(20)
- STATUS — VARCHAR2(20)
- ACQUIRED_AT — DATE
- DISPOSED_AT — DATE
- DISPOSAL_METHOD — VARCHAR2(20)
- PURCHASE_PRICE — NUMBER(10,2)
- TARGET_PRICE — NUMBER(10,2)
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP
ECO_POINT_TRANSACTIONS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- POINTS — NUMBER(10) — NOT NULL
- REASON_TYPE — VARCHAR2(50) — NOT NULL
- DESCRIPTION — VARCHAR2(255)
- CREATED_AT — TIMESTAMP — NOT NULL
EMAIL_VERIFICATION_TOKENS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- TOKEN — VARCHAR2(255) — NOT NULL
- EXPIRES_AT — TIMESTAMP — NOT NULL
- USED_AT — TIMESTAMP
- CREATED_AT — TIMESTAMP — NOT NULL
MATERIAL_ENERGY_FACTORS
- ID — NUMBER(19) — Primary key — NOT NULL
- MATERIAL — VARCHAR2(50) — NOT NULL
- UNIT — VARCHAR2(20) — NOT NULL
- ENERGY_KWH_PER_UNIT — NUMBER(10,4)
- WATER_L_PER_UNIT — NUMBER(10,4)
- CO2_KG_PER_UNIT — NUMBER(10,4) — NOT NULL
OAUTH_ACCOUNTS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- PROVIDER — VARCHAR2(50) — NOT NULL
- PROVIDER_USER_ID — VARCHAR2(255) — NOT NULL
- LINKED_AT — TIMESTAMP — NOT NULL
OUTFITS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- TITLE — VARCHAR2(255)
- DESCRIPTION — VARCHAR2(500)
- SOURCE — VARCHAR2(20)
- CONTEXT_TAG — VARCHAR2(50)
- CONTEXT_WEATHER — VARCHAR2(50)
- CREATED_AT — TIMESTAMP — NOT NULL
OUTFIT_ITEMS
- ID — NUMBER(19) — Primary key — NOT NULL
- OUTFIT_ID — NUMBER(19) — NOT NULL
- CLOTHING_ITEM_ID — NUMBER(19) — NOT NULL
- ROLE — VARCHAR2(20)
- CREATED_AT — TIMESTAMP — NOT NULL
PICKUP_REQUESTS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- CLOTHING_ITEM_ID — NUMBER(19)
- TYPE — VARCHAR2(20) — NOT NULL
- STATUS — VARCHAR2(20)
- PICKUP_ADDRESS — VARCHAR2(500)
- DESIRED_DATE — DATE
- MEMO — VARCHAR2(500)
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP
POSTS
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- CATEGORY — VARCHAR2(50) — NOT NULL
- TITLE — VARCHAR2(255) — NOT NULL
- CONTENT — CLOB — NOT NULL
- VIEW_COUNT — NUMBER(10)
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP
PROFILE_IMAGE_HISTORY
- HIST_ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- IMAGE_PATH — VARCHAR2(255) — NOT NULL
- UPLOADED_AT — DATE — NOT NULL
RECYCLING_CENTERS
- ID — NUMBER(19) — Primary key — NOT NULL
- NAME — VARCHAR2(255) — NOT NULL
- TYPE — VARCHAR2(20) — NOT NULL
- ADDRESS — VARCHAR2(500)
- LAT — NUMBER(10,7)
- LON — NUMBER(10,7)
- OPEN_HOURS — VARCHAR2(255)
- PHONE — VARCHAR2(50)
- HOMEPAGE_URL — VARCHAR2(500)
- CREATED_AT — TIMESTAMP — NOT NULL
USERS
- ID — NUMBER(19) — Primary key — NOT NULL
- LOGIN_ID — VARCHAR2(50) — NOT NULL
- PASSWORD — VARCHAR2(255) — NOT NULL
- NAME — VARCHAR2(100) — NOT NULL
- PHONE — VARCHAR2(20)
- EMAIL — VARCHAR2(255)
- ADDRESS — VARCHAR2(255)
- BIRTH_DATE — DATE
- ROLE — VARCHAR2(20)
- STATUS — VARCHAR2(20)
- MEM_IMG — VARCHAR2(255)
- CREATED_AT — TIMESTAMP — NOT NULL
- UPDATED_AT — TIMESTAMP
USER_BADGES
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- BADGE_ID — NUMBER(19) — NOT NULL
- AWARDED_AT — TIMESTAMP — NOT NULL
USER_ENERGY_STATS_DAILY
- ID — NUMBER(19) — Primary key — NOT NULL
- USER_ID — NUMBER(19) — NOT NULL
- STAT_DATE — DATE — NOT NULL
- RECYCLED_KG — NUMBER(10,2)
- WATER_SAVED_L — NUMBER(12,2)
- CO2_SAVED_KG — NUMBER(12,2)
- ITEMS_COUNT — NUMBER(10)
- CREATED_AT — TIMESTAMP — NOT NULL
USER_PROFILES
- USER_ID — NUMBER(19) — Primary key — NOT NULL
- NICKNAME — VARCHAR2(50)
- AVATAR_URL — VARCHAR2(500)
- TOTAL_WATER_SAVED_L — NUMBER(12,2)
- TOTAL_CARBON_SAVED_KG — NUMBER(12,2)
- ECO_POINTS — NUMBER(10)
- TOTAL_COLLECTED_KG — NUMBER(12,2)
- TOTAL_CLOTHING_COUNT — NUMBER(10)
- LAST_LOGIN_AT — TIMESTAMP