dating-demo
Tables (13)
ChatMessages
- messageId — BIGINT
- chatRoomId — BIGINT
- senderId — BIGINT
- message — TEXT
- createdDate — TIMESTAMP
ChatRooms
- chatId — BIGINT
- first_user_id — BIGINT
- second_user_id — BIGINT
- identifier — VARCHAR(50)
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
- expires_at — TIMESTAMP
EventLogs
- logId — BIGINT
- userId — BIGINT
- eventType — VARCHAR(100)
- eventData — JSON
- createdDate — TIMESTAMP
Gifts
- giftId — BIGINT
- senderId — BIGINT
- receiverId — BIGINT
- storeId — BIGINT
- menuId — BIGINT
- message — VARCHAR(255)
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED')
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
Knocks
- knockId — BIGINT
- senderId — BIGINT
- receiverId — BIGINT
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED')
- createdDate — TIMESTAMP
Matchings
- matchId — BIGINT
- senderId — BIGINT
- receiverId — BIGINT
- status — ENUM('PENDING', 'MATCHED', 'REJECTED')
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
Notifications
- notificationId — BIGINT
- userId — BIGINT
- type — ENUM('KNOCK', 'GIFT', 'MATCH', 'SYSTEM')
- content — VARCHAR(255)
- relatedId — BIGINT
- is_read — BOOLEAN
- is_deleted — BOOLEAN
- createdDate — TIMESTAMP
QRCodes
- qrId — BIGINT
- storeId — BIGINT
- code — VARCHAR(255)
- location_description — VARCHAR(255)
- createdDate — TIMESTAMP
Stores
- storeId — BIGINT
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(20)
- address — VARCHAR(255)
- phone — VARCHAR(20)
- storePictureUrl — TEXT
- content — VARCHAR(255)
- rating — DECIMAL(2,1)
- dibsCount — INT
- reviewCount — INT
- operationHours — VARCHAR(255)
- closedDays — VARCHAR(255)
- latitude — DECIMAL(10, 6)
- longitude — DECIMAL(10, 6)
- max_capacity — INT
- current_users — INT
- seating_chart — JSON
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
- status — ENUM('일반', '휴업', '폐점')
Subscriptions
- subscription_id — BIGINT
- userId — BIGINT
- plan_type — ENUM('1_MONTH', '3_MONTHS', '6_MONTHS', '1_YEAR')
- status — ENUM('ACTIVE', 'EXPIRED', 'CANCELLED')
- start_date — TIMESTAMP
- expiry_date — TIMESTAMP
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
Tags
- tagId — BIGINT
- tagName — VARCHAR(50)
UserTags
- userTagId — BIGINT
- userId — BIGINT
- tagId — BIGINT
- createdDate — TIMESTAMP
Users
- userId — BIGINT
- oauth_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
- grade — ENUM('고마운분', '귀한분', '더귀한분', '천생연분')
- role — ENUM('회원', '관리자')
- profile_url — VARCHAR(255)
- currentAddress — VARCHAR(255)
- age — INT
- gender — ENUM('M', 'F')
- membership_type — ENUM('FREE', 'PREMIUM')
- expiry_date — TIMESTAMP
- createdDate — TIMESTAMP
- modifiedDate — TIMESTAMP
- status — ENUM('일반', '정지', '탈퇴')