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