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