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