siso

Tables (17)

Administrator

  • id — BIGINT — Primary key — NOT NULL

CallReview

  • id — BigInt — Primary key — NOT NULL
  • call_iid — BigInt — Foreign key → Calls.id — NOT NULL
  • score — Int — NOT NULL
  • comment — VarChar(255)
  • create_at — DateTime — NOT NULL — TimeStamp

Calls

  • id — BigInt — Primary key — NOT NULL
  • caller_id — BigInt — Foreign key → Users.id — NOT NULL
  • receiver_id — BigInt — Foreign key → Users.id — NOT NULL
  • status — Enum — NOT NULL
  • duration — Int — NOT NULL
  • started_at — DateTime — NOT NULL — TimeStamp
  • ended_at — DateTime — NOT NULL — TimeStamp
  • agora_channel_id — Varchar(255) — NOT NULL
  • agora_token — Varchar(255) — NOT NULL

ChatMessages

  • id — BigInt — Primary key — NOT NULL
  • chatRoom_id — BigInt — Foreign key → ChatRooms.id — NOT NULL
  • sender_id — BigInt — Foreign key → Users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • updated_at — DateTime — NOT NULL — TimeStamp
  • deleted — Boolean — NOT NULL — 소프트딜리트

ChatRoomLimits

  • id — BigInt — Primary key — NOT NULL
  • chat_room_id — BigInt — Foreign key → ChatRooms.id — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • messageCount — int

ChatRoomMembers

  • id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • chatRoom_id — BigInt — Foreign key → ChatRooms.id — NOT NULL
  • lastReadMessageId — Int — NOT NULL

ChatRooms

  • id — BigInt — Primary key — NOT NULL
  • call_id — BigInt — Foreign key → Calls.id — NOT NULL
  • status — Enum — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • updated_at — DateTme — NOT NULL — TimeStamp

FcmToken

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • token — String — NOT NULL
  • device_type — Enum — NOT NULL
  • is_active — boolean
  • user_id — BigInt — Foreign key → Users.id — NOT NULL

Images

  • id — PRIMARY — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • path — VarChar(255) — NOT NULL
  • server_image_name — VarChar(255) — NOT NULL
  • original_name — VarChar(255) — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • updated_at — DateTime — NOT NULL

Interests

  • id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • interest — Varchar(40) — NOT NULL

Notifications

  • id — BIGINT — Primary key — NOT NULL
  • receiver_id — BIGINT — NOT NULL
  • sender_id — BIGINT — NOT NULL
  • sender_nickname — VarChar(50) — NOT NULL
  • title — VarChar(50) — NOT NULL
  • type — Enum — NOT NULL
  • message — Text — NOT NULL
  • is_read — Boolean — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • url — VarChar(255) — NOT NULL

Payments

  • id — BigInt — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • method — Varchar(50) — NOT NULL
  • status — Enum — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp

PaymentsHistory

  • id — BigInt — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Payments.id — NOT NULL
  • payment_id — BigInt — Foreign key → Payments.id — NOT NULL
  • item — Enum — NOT NULL — 무엇을 구매했는지
  • amount — Int — NOT NULL
  • payment_status — Enum — NOT NULL — Pending, Success, Failed, Refunded
  • payment_method — Enum — NOT NULL — Toss, Kakaopay
  • created_at — DateTime — NOT NULL — TimeStamp

Profile

  • id — PRIMARY — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • drinking_capacity — Enum
  • religion — Enum
  • is_smoke — Boolean
  • age — Int — NOT NULL
  • nickname — Varchar(50) — NOT NULL
  • introduce — Varchar(255) — 기본값: 안녕하세요 (닉네임) 입니다
  • contact — ENUM
  • profile_Image — URL — NOT NULL
  • location — Enum — NOT NULL
  • sex — Enum — NOT NULL
  • mbti — Enum
  • preference_sex — Enum — NOT NULL
  • bond — String
  • profile_image_id — PRIMARY — Foreign key → Images.id — NOT NULL

Reports

  • id — PRIMARY — Primary key — NOT NULL
  • reporter — PRIMARY — Foreign key → Users.id — NOT NULL
  • reported — PRIMARY — Foreign key → Users.id — NOT NULL
  • report_title — Varchar(50) — NOT NULL
  • description — Text — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • repoted_type — Enum — NOT NULL

Users

  • id — BigInt — Primary key — NOT NULL
  • email — Varchar(20) — NOT NULL
  • provider — Enum — NOT NULL
  • phone_number — Varchar(20) — NOT NULL
  • registrationStatus — Enum — NOT NULL
  • presenceStatus — Enum — NOT NULL
  • refreshtoken — VarChar(255)
  • notification_subscribed — Boolean — NOT NULL
  • is_block — Boolean — NOT NULL
  • is_deleted — Boolean — NOT NULL
  • created_at — DateTime — NOT NULL — TimeStamp
  • updated_at — DateTime — NOT NULL — TimeStamp
  • deleted_at — DateTime — TimeStamp

VoiceSamples

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BigInt — Foreign key → Users.id — NOT NULL
  • url — VarChar(255) — NOT NULL
  • duration — Int — NOT NULL
  • file_size — int — NOT NULL — 바이트로 받기
  • created_at — DateTime — NOT NULL — TimeStamp
  • updated_at — DateTime — NOT NULL — TimeStamp