프로젝트
테이블 (13)
BETTING_LOGS
- BET_ID — NUMBER
- BETTOR_EMAIL — VARCHAR(100)
- GAME_ID — NUMBER
- POINTS_BET — NUMBER — NOT NULL
- POINTS_WON — NUMBER
- RESULT — VARCHAR(20)
- CREATED_AT — TIMESTAMP
BLOCKED_USERS
- BLOCKER_EMAIL — VARCHAR(100)
- BLOCKED_EMAIL — VARCHAR(100)
- REASON — VARCHAR(255)
- BLOCKED_AT — TIMESTAMP
BLUETOOTH_CONNECTION_LOGS
- LOG_ID — NUMBER
- DEVICE_ID — NUMBER
- CONNECTOR_EMAIL — VARCHAR(100)
- CONNECTED_AT — TIMESTAMP
- DATA_SENT — VARCHAR(255)
- DATA_RECEIVED — VARCHAR(255)
BLUETOOTH_DEVICES
- DEVICE_ID — NUMBER
- OWNER_EMAIL — VARCHAR(100)
- DEVICE_NAME — VARCHAR(100)
- MAC_ADDRESS — VARCHAR(50)
- LAST_CONNECTED_AT — TIMESTAMP
CHAT_MESSAGE
- MESSAGE_ID — NUMBER
- ROOM_ID — NUMBER
- SENDER_EMAIL — VARCHAR(100)
- CONTENT — VARCHAR(255)
- CREATED_AT — TIMESTAMP
CHAT_ROOM
- ROOM_ID — NUMBER
- ROOM_NAME — VARCHAR(100)
- IS_PUBLIC — NUMBER(1)
- CREATED_AT — TIMESTAMP
GAME_RECORDS
- GAME_ID — NUMBER
- EMAIL — VARCHAR(100)
- SCORE — NUMBER
- CREATED_AT — TIMESTAMP
MUTE_LIST
- MUTE_ID — NUMBER
- MUTE_BY_EMAIL — VARCHAR(100)
- TARGET_EMAIL — VARCHAR(100)
- ROOM_ID — NUMBER
- MUTED_AT — TIMESTAMP
POINT_HISTORY
- POINT_ID — NUMBER
- SENDER_EMAIL — VARCHAR(100)
- RECEIVER_EMAIL — VARCHAR(100)
- POINTS_CHANGE — NUMBER — NOT NULL
- REASON — VARCHAR(255)
- CREATED_AT — TIMESTAMP
REWARD_ITEMS
- ITEM_ID — NUMBER
- NAME — VARCHAR(100) — NOT NULL
- IMAGE_URL — VARCHAR(255)
- PRICE — NUMBER — NOT NULL
- DESCRIPTION — VARCHAR(255)
- REWARD_TYPE — VARCHAR(20)
- CONDITION_VALUE — NUMBER
USERS
- EMAIL — VARCHAR(100)
- PASSWORD — VARCHAR(255) — NOT NULL
- NICKNAME — VARCHAR(50)
- NAME — VARCHAR(20)
- BIRTHDATE — DATE
- PROFILE_PICTURE_URL — VARCHAR(255)
- POINTS — NUMBER
- CHAT_COUNT — NUMBER
- IS_ACTIVE — NUMBER(1)
- CREATED_AT — TIMESTAMP
USER_REWARDS
- ITEM_ID — NUMBER
- OWNER_EMAIL — VARCHAR(100)
- SENDER_EMAIL — VARCHAR(100)
- REDEEMED_AT — TIMESTAMP
- LAST_REDEEMED_AT — TIMESTAMP
VERIFICATION_TOKENS
- TOKEN_ID — NUMBER
- EMAIL — VARCHAR(100)
- TOKEN — VARCHAR(255)
- EXPIRES_AT — TIMESTAMP