Copy

Tables (8)

EMO_LIST

  • Key (EMO_ID) — BIGINT — Primary key — NOT NULL
  • Key (PARENTS_ID) — BIGINT — Foreign key → EMO_LIST.Key — NOT NULL
  • Field (SET_ID) — BIGINT
  • Field2 (FILE_NAME) — VARCHAR(512)
  • Field3 (FILE_PATH) — VARCHAR(512)
  • Field4 (PRICE) — VARCHAR(256)
  • Field5 (COUNT) — INT
  • Field6 (STATUS) — ENUM
  • Field7 (REG_DATE) — DATETIME

FRIEND_LIST

  • Field2 (USERNAME) — VARCHAR(256) — Foreign key → USER.Field2
  • Field2 (FRIEND_NAME) — VARCHAR(256) — Foreign key → USER.Field2
  • Field (STATUS) — ENUM — pending: 친구 요청 대기 상태 accepted: 친구 요청 수락 상태 rejected: 친구 요청 거절 상태 차단
  • Field2 (REG_DATE) — DATETIME

INTEREST

  • Key (INTEREST_ID) — BIGINT — Primary key — NOT NULL
  • Field (NAME) — VARCHAR(256)
  • Field3 (REG_DATE) — DATETIME

MEM_INTEREST (USER_INTEREST)

  • Key (USER_INTEREST_ID) — LONG — Primary key — NOT NULL
  • Field2 (USERNAME) — VARCHAR(256) — Foreign key → USER.Field2
  • Key (INTEREST_ID) — BIGINT — Foreign key → INTEREST.Key — NOT NULL
  • Field (REG_DATE) — DATETIME

MY_EMO

  • Key (MY_EMO_ID) — BIGINT — Primary key — NOT NULL
  • Field2 (USERNAME) — VARCHAR(256) — Foreign key → USER.Field2
  • Key (EMO_ID) — BIGINT — Foreign key → EMO_LIST.Key — NOT NULL
  • Field2 (STATUS) — ENUM
  • Field3 (REG_DATE) — DATETIME

NATION

  • Field (NATION_NAME) — VARCHAR(100) — Primary key
  • Field (NATION_FULLNAME) — VARCHAR(100)
  • Field (LANG) — VARCHAR(100)

PAYMENT

  • Key (PAY_ID) — BIGINT — Primary key — NOT NULL
  • Key (MY_EMO_ID) — VARCHAR(256) — Foreign key → MY_EMO.Key — NOT NULL
  • Field (DISCOUNT) — BIGINT
  • Field2 (PRICE) — BIGINT
  • Field3 (METHOD) — ENUM
  • Field4 (TRANSACTION_ID) — VARCHAR(256)
  • Field5 (STATUS) — ENUM
  • Field6 (REG_DATE) — DATETIME
  • Field7 (CANCLE_DATE) — DATETIME

USER

  • Field2 (USERNAME) — VARCHAR(256) — Primary key
  • Field (NICK_NAME) — VARCHAR(256)
  • Field (NATION_NAME) — VARCHAR(256) — NOT NULL
  • Field8 (STATUS) — ENUM
  • Field9 (IS_PUBLIC) — BIT
  • Field (IS_USER) — BIT
  • Field10 (PHOTO_PATH) — VARCHAR(512)
  • Field11 (KEYWORD) — VARCHAR(512)
  • Field7 (REG_DATE) — DATETIME