ERD-SKN-FINAL-2
Tables (9)
CHAT (채팅)
- Key (CHAT_ID) — UNSIGNED INT — Primary key — NOT NULL
- Field1 (TITLE) — VARCHAR(100)
- Field2 (CREATED_AT) — DATETIME
- Field3 (IS_DELETED) — BOOLEAN
- Key (USER_ID) — CHAR(32) — Foreign key → USER.Key — NOT NULL
CHAT_MESSAGE (채팅 메세지)
- Key (MSG_ID) — UNSIGNED INT — Primary key — NOT NULL
- FK (CHAT_ID) — UNSIGNED INT — Foreign key → CHAT.Key — NOT NULL
- Field1 (SENDER) — VARCHAR(20)
- Field2 (MESSAGE) — TEXT
- Field3 (CREATED_AT) — DATETIME
CHAT_RECOMMENDATION (채팅 추천 상품)
- Key (RCMD_ID) — UNSIGNED INT — Primary key — NOT NULL
- FK (MSG_ID) — UNSIGNED INT — Foreign key → CHAT_MESSAGE.Key — NOT NULL
- FK (PRODUCT_ID) — UNSIGNED INT — Foreign key → PRODUCT.Key — NOT NULL
- Field1 (IS_LIKED) — BOOLEAN
- Field2 (CREATED_AT) — DATETIME
FEEDBACK (피드백)
- Key (FEEDBACK_ID) — UNSIGNED INT — Primary key — NOT NULL
- Key (MSG_ID) — UNSIGNED INT — Foreign key → CHAT_MESSAGE.Key — NOT NULL
- Field (FEEDBACK) — BOOLEAN
- Field2 (CREATED_AT) — DATETIME
- Field3 (UPDATED_AT) — DATETIME
PREFER_TYPE (선호 타입)
- Key (PREFER_ID) — UNSIGNED INT — Primary key — NOT NULL
- Field (TYPE) — VARCHAR(20)
- Field2 (TYPE_NAME) — VARCHAR(100)
PRODUCT (상품)
- Key (PRODUCT_ID) — UNSIGNED INT — Primary key — NOT NULL
- Field1 (BRAND) — VARCHAR(255)
- Field2 (NAME) — VARCHAR(255)
- Field3 (CATEGORY) — VARCHAR(100)
- Field4 (SUB_CATEGORY) — VARCHAR(100)
- Field5 (OPTIONS) — VARCHAR(255)
- Field6 (LINK) — VARCHAR(255)
- Field7 (THUMBNAIL_URL) — VARCHAR(255)
- Field8 (PRICE) — UNSIGNED INT
- Field9 (CREATED_AT) — DATETIME
RECIPIENT (수령인 정보)
- Key (CHAT_ID) — UNSIGNED INT — Foreign key → CHAT.Key — NOT NULL
- Field1 (GENDER) — CHAR(8)
- Field2 (AGE_GROUP) — VARCHAR(20)
- Field3 (RELATION) — VARCHAR(20)
- Field4 (ANNIVERSARY) — VARCHAR(50)
- Field5 (SITUATION_INFO) — TEXT
- Field6 (CREATED_AT) — DATETIME
USER (회원)
- Key (USER_ID) — CHAR(32) — Primary key — NOT NULL
- Field1 (EMAIL) — VARCHAR(255)
- Field2 (PASSWORD) — VARCHAR(255)
- Field3 (NICKNAME) — VARCHAR(50)
- Field4 (BIRTH) — CHAR(8)
- Field5 (GENDER) — CHAR(8)
- Field6 (JOB) — VARCHAR(50)
- Field7 (PROFILE_IMAGE) — VARCHAR(255)
- Field8 (TYPE) — VARCHAR(10)
- Field9 (SOCIAL_PROVIDER) — VARCHAR(10)
- Field10 (IS_EMAIL_VERIFIED) — BOOLEAN
- Field11 (CREATED_AT) — DATETIME
- Field12 (UPDATED_AT) — DATETIME
USER_PREFER (회원 선호 타입)
- Key (PREFER_ID) — UNSIGNED INT — Foreign key → PREFER_TYPE.Key — NOT NULL
- Key (USER_ID) — CHAR(32) — Foreign key → USER.Key — NOT NULL
- Field (CREATED_AT) — DATETIME
- Field2 (UPDATED_AT) — DATETIME