siso
Tables (17)
Administrator
- id — BIGINT — Primary key — NOT NULL
CallReview
- id — BigInt — Primary key — NOT NULL
- call_id — 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
- 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
- 발신자 (caller_id) — BigInt — Foreign key → Users.id — NOT NULL
- 받는 사람 (receiver_id) — BigInt — Foreign key → Users.id — NOT NULL
ChatMessages
- id — BigInt — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — DateTime — NOT NULL — TimeStamp
- updated_at — DateTime — NOT NULL — TimeStamp
- deleted — Boolean — NOT NULL — 소프트딜리트
- 채팅방id (chatRoom_id) — BigInt — Foreign key → ChatRooms.id — NOT NULL
- sender_id — BigInt — Foreign key → Users.id — NOT NULL
ChatRoomLimits
- id — BigInt — Primary key — NOT NULL
- messageCount — int
- user_id — BigInt — Foreign key → Users.id — NOT NULL
- chat_room_id — BigInt — Foreign key → ChatRooms.id — NOT NULL
ChatRoomMembers
- id — VARCHAR(255) — Primary key — NOT NULL
- lastReadMessageId — Int — NOT NULL
- chatRoom_id — BigInt — Foreign key → ChatRooms.id — NOT NULL
- user_id — BigInt — Foreign key → Users.id — NOT NULL
ChatRooms
- id — BigInt — Primary key — NOT NULL
- call_id — BigInt — Foreign key → CallReview.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
- foreign (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
- foreign (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 → Users.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
- report_title — Varchar(50) — NOT NULL
- description — Text — NOT NULL
- created_at — DateTime — NOT NULL — TimeStamp
- repoted_type — Enum — NOT NULL
- reporter — BigInt — Foreign key → Users.id — NOT NULL
- reported — BigInt — Foreign key → Users.id — 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
- foreign (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