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('일반', '정지', '탈퇴')