코디핏

테이블 (18)

CALENDAR_DAYS

  • USER_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • WEAR_DATE — DATE — 기본 키 — NOT NULL
  • RESULT_FILE_ID — NUMBER
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

CALENDAR_ITEMS

  • USER_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • WEAR_DATE — DATE — 기본 키 — NOT NULL
  • ITEM_TYPE — VARCHAR2(20) — 기본 키 — NOT NULL
  • ITEM_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP

CATEGORIES

  • CATEGORY_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CATEGORY_NAME — VARCHAR2(50) — NOT NULL
  • PARENT_ID — VARCHAR2(10)
  • SORT_ORDER — NUMBER(3)
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP

CLOTHES

  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(10) — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • BRAND — VARCHAR2(100)
  • CATEGORY_ID — VARCHAR2(10) — NOT NULL
  • SIZE — VARCHAR2(20)
  • PRICE — NUMBER(10)
  • PURCHASE_DATE — DATE
  • PURCHASE_URL — VARCHAR2(1000)
  • DESCRIPTION — VARCHAR2(1000)
  • WEAR_COUNT — NUMBER(5)
  • LAST_WORN_DATE — DATE
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

CLOTHES_HISTORY

  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — 기본 키 — NOT NULL
  • ACTION_TYPE — VARCHAR2(20) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(10)
  • NAME — VARCHAR2(100)
  • BRAND — VARCHAR2(100)
  • CATEGORY_ID — VARCHAR2(10)
  • SIZE — VARCHAR2(20)
  • PRICE — NUMBER(10)
  • PURCHASE_DATE — DATE
  • PURCHASE_URL — VARCHAR2(1000)
  • DESCRIPTION — VARCHAR2(1000)
  • WEAR_COUNT — NUMBER(5)
  • LAST_WORN_DATE — DATE
  • IS_ACTIVE — CHAR(1)

CLOTHES_IMAGES

  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • FILE_ID — NUMBER — 기본 키 — NOT NULL
  • SORT_ORDER — NUMBER(3)
  • CREATED_AT — TIMESTAMP

COMMENTS

  • COMMENT_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • POST_ID — VARCHAR2(10) — NOT NULL
  • USER_ID — VARCHAR2(10) — NOT NULL
  • PARENT_ID — VARCHAR2(10)
  • CONTENT — VARCHAR2(1000) — NOT NULL
  • LIKE_COUNT — NUMBER(10)
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

FILE_INFO

  • FILE_ID — NUMBER — 기본 키 — NOT NULL
  • ORIGINAL_NAME — VARCHAR2(255) — NOT NULL
  • S3_KEY — VARCHAR2(500) — NOT NULL
  • S3_URL — VARCHAR2(1000) — NOT NULL
  • BUCKET_NAME — VARCHAR2(100) — NOT NULL
  • FILE_SIZE — NUMBER
  • FILE_TYPE — VARCHAR2(100)
  • UPLOAD_BY — VARCHAR2(10)
  • UPLOAD_DATE — TIMESTAMP — NOT NULL

LIKES

  • USER_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • TARGET_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP

LOOKS

  • LOOK_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(10) — NOT NULL
  • LOOK_NAME — VARCHAR2(100) — NOT NULL
  • DESCRIPTION — VARCHAR2(1000)
  • FILE_ID — NUMBER
  • CREATION_TYPE — VARCHAR2(20) — NOT NULL
  • IS_FAVORITE — CHAR(1)
  • WEAR_COUNT — NUMBER(5)
  • LAST_WORN_DATE — DATE
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

LOOKS_HISTORY

  • LOOK_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — 기본 키
  • ACTION_TYPE — VARCHAR2(20) — 기본 키 — NOT NULL
  • LOOK_NAME — VARCHAR2(100) — NOT NULL
  • DESCRIPTION — VARCHAR2(1000)
  • FILE_ID — NUMBER
  • CREATION_TYPE — VARCHAR2(20) — NOT NULL
  • IS_FAVORITE — CHAR(1)
  • WEAR_COUNT — NUMBER(5)
  • LAST_WORN_DATE — DATE
  • IS_ACTIVE — CHAR(1)

LOOK_ITEMS

  • LOOK_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP

LOOK_ITEM_COORDINATES

  • LOOK_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • POSITION_X — NUMBER(10,2) — NOT NULL
  • POSITION_Y — NUMBER(10,2) — NOT NULL
  • WIDTH — NUMBER(10,2) — NOT NULL
  • HEIGHT — NUMBER(10,2) — NOT NULL
  • ROTATION — NUMBER(5,2)
  • Z_INDEX — NUMBER(3)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

LOOK_ITEM_COORDINATES_HISTORY

  • LOOK_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CLOTHES_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • CREATED_AT — TIMESTAMP — 기본 키 — NOT NULL
  • ACTION_TYPE — VARCHAR2(20) — 기본 키 — NOT NULL
  • POSITION_X — NUMBER(10,2)
  • POSITION_Y — NUMBER(10,2)
  • WIDTH — NUMBER(10,2)
  • HEIGHT — NUMBER(10,2)
  • ROTATION — NUMBER(5,2)
  • Z_INDEX — NUMBER(3)

POSTS

  • POST_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(10) — NOT NULL
  • TITLE — VARCHAR2(200) — NOT NULL
  • CONTENT — CLOB
  • IS_PUBLIC — CHAR(1)
  • VIEW_COUNT — NUMBER(10)
  • LIKE_COUNT — NUMBER(10)
  • COMMENT_COUNT — NUMBER(10)
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

POST_IMAGES

  • POST_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • FILE_ID — NUMBER — 기본 키 — NOT NULL
  • SORT_ORDER — NUMBER(3)
  • CREATED_AT — TIMESTAMP

USERS

  • USER_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • EMAIL — VARCHAR2(100)
  • PASSWORD — VARCHAR2(255)
  • NICKNAME — VARCHAR2(50) — NOT NULL
  • PROFILE_IMAGE_ID — NUMBER
  • LOGIN_TYPE — VARCHAR2(20) — NOT NULL
  • KAKAO_ID — VARCHAR2(100)
  • GENDER — VARCHAR2(10)
  • BIRTH_DATE — DATE
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • LOGINED_AT — TIMESTAMP

USER_AVATARS

  • AVATAR_ID — VARCHAR2(10) — 기본 키 — NOT NULL
  • USER_ID — VARCHAR2(10) — NOT NULL
  • AVATAR_NAME — VARCHAR2(100)
  • FILE_ID — NUMBER — NOT NULL
  • IS_ACTIVE — CHAR(1)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP