NDTALK
Tables (10)
account
- id — bigint — Primary key — NOT NULL
- nickname — varchar(20)
- third_party_auth_type — varchar(20) — NOT NULL
- third_party_auth_uid — varchar(512) — NOT NULL
- is_agreement — tinyint — 필수 약관 항목 동의 여부
- email — varchar(512) — NOT NULL
- birth_year — int — 생년
- latitude — decimal(16, 14) — 위도
- longitude — decimal(17, 14) — 경도
- about_me — varchar(512) — 자기소개
- enable — tinyint
- push_token — varchar(1024)
- gender — tinyint — 1: 여성, 2: 남성
- job — varchar(100) — `ideal_type` varchar(255) DEFAULT NULL COMMENT ' `living_arrangement` varchar(100) DEFAULT NULL COMMENT ' `mbti` varcha…
- recent_at — datetime — 최근접속 시간
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
account_image
- id — bigint — Primary key — NOT NULL
- account_id — bigint — Foreign key → account.id — NOT NULL
- image_path — varchar(1024) — NOT NULL
- created_at — datetime — NOT NULL — 생성일시
agreement
- id — bigint — Primary key — NOT NULL — 자동증가 ID
- account_id — bigint — Foreign key → account.id — NOT NULL — 계정 ID
- agreement_type — varchar(50) — NOT NULL — 동의종류
- is_agreed — tinyint(1) — NOT NULL — 동의여부
- created_at — datetime — NOT NULL — 생성일시
- updated_at — datetime — 수정일시
- deleted_at — datetime — 삭제일시
app_usage_environment
- id — bigint — Primary key — NOT NULL
- account_id — bigint — Foreign key → account.id — NOT NULL
- device_model_name — varchar(100)
- app_os — varchar(20)
- app_version — varchar(100)
- app_push_token — varchar(1500)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
auth_token
- id — bigint — Primary key — NOT NULL
- account_id — bigint — Foreign key → account.id — NOT NULL
- access_token — varchar(512) — NOT NULL
- refresh_token — varchar(512) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
chat
- id — bigint — Primary key — NOT NULL
- message_type — varchar(20) — NOT NULL
- message_id — bigint — NOT NULL
- message_content_type — varchar(20) — NOT NULL
- message_content — varchar(3000) — NOT NULL
- writer_account_id — bigint — Foreign key → account.id — NOT NULL — 보낸사람
- written_at — datetime — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
- room_hash_key — varchar(512) — NOT NULL
join_chat_room
- id — bigint — Primary key — NOT NULL
- account_id — bigint — Foreign key → account.id — NOT NULL
- partner_account_id — bigint — NOT NULL
- room_id — bigint — Foreign key → room.id — NOT NULL — Room ID
- created_at — datetime — NOT NULL — 생성일시
- updated_at — datetime — 수정일시
- deleted_at — datetime — 삭제일시
region
- id — int — Primary key — NOT NULL
- country_id — int — NOT NULL
- code — varchar(10) — NOT NULL
- name — varchar(100) — NOT NULL
report
- id — bigint — Primary key — NOT NULL
- reporter_id — bigint — Foreign key → account.id — NOT NULL
- reported_id — bigint — Foreign key → account.id — NOT NULL
- report_type — varchar(100) — NOT NULL
- content — varchar(5000)
- answer_content — varchar(5000)
- answered_at — datetime
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime
room
- id — bigint — Primary key — NOT NULL
- room_hash_key — varchar(512) — NOT NULL
- creator_account_id — bigint — Foreign key → account.id
- partner_account_id — bigint — Foreign key → account.id
- member_count — int
- unread_count — int
- inactive — tinyint
- exit_creator — tinyint
- exit_partner — tinyint
- last_message_from_account — bigint
- last_message_content — varchar(3000)
- last_message_sent_at — datetime
- last_message_type — varchar(10)
- last_message_content_type — varchar(10)
- created_at — datetime — NOT NULL
- updated_at — datetime
- deleted_at — datetime