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