코디핏
테이블 (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