buddyya

Tables (18)

admin (Untitled14)

  • Key — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • image_url (Field) — blob

avatar

  • id (아이디) — bigint — Primary key — NOT NULL
  • student_id (아이디2) — bigint — Foreign key → student.id — NOT NULL — 학생 참조 아이디
  • version (버전) — bigint — NOT NULL — 배포 버전
  • phone_number (휴대폰 번호) — varchar — 휴대폰 번호
  • notification_enabled (알림 허용 여부) — bit — 알림 허용 여부
  • active (유저 활동 여부) — bit — NOT NULL — 유저 활동 여부
  • logged_out (로그아웃 여부) — bit — 유저 로그아웃 여부
  • created_date (계정 생성 일시) — datetime — 생성 날짜
  • updated_date (Field) — datetime — 수정 날짜
  • deactivated_date (계정 탈퇴 일시) — datetime — 로그아웃 및 탈퇴 날짜

chat (Untitled13)

  • id (Key) — bigint — Primary key — NOT NULL
  • chatroom_id (Key2) — bigint — Foreign key → chatroom.id — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • type (Field) — varchar — 메세지 타입
  • message (Field2) — text — 메시지
  • image_url (Field3) — varchar — 채팅 이미지
  • created_date (Field4) — datetime — 생성날짜

chatroom (Untitled12)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar

fcm_token (Untitled9)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • token (Field) — varchar — 토근 값

feed (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • category (Field7) — varchar — 피드 카테고리
  • title (Field) — varchar — 피드 제목
  • content (Field2) — text — 피드 내용
  • like_count (Field3) — int — 좋아요 개수
  • comment_count (Field4) — int — 댓글 개수
  • created_date (Field5) — datetime — 생성 날짜
  • updated_date (Field6) — datetime — 수정 날짜

feed_comment (Untitled4)

  • Key — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • feed_id (Key2) — bigint — Foreign key → feed.id — NOT NULL
  • content (Field) — text — 댓글 내용
  • created_date (Field2) — datetime — 생성 날짜
  • updated_date (Field3) — datetime — 수정 날짜

feed_image (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • feed_id (Key2) — bigint — Foreign key → feed.id — NOT NULL
  • url (Field2) — varchar — 배포된 이미지 URL

feed_like (Untitled6)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • feed_id (Key2) — bigint — Foreign key → feed.id — NOT NULL

interest (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar — 관심사 이름

language

  • id (아이디) — bigint — Primary key — NOT NULL
  • name (Field) — varchar — 언어 이름

match_request (Untitled10)

  • id (Key) — bigint — Primary key — NOT NULL
  • id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • created_date (Field) — datetime — 생성 날짜
  • korean (Field2) — bit — 한국인 여부

matched (Untitled11)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • chatroom_id (Key2) — bigint — Foreign key → chatroom.id — NOT NULL
  • buddy_id (Field2) — bigint
  • created_time (Field) — datetime

notification (Untitled8)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • title (Field) — varchar — 알림 제목
  • message (Field2) — varchar — 알림 내용
  • type (Field4) — varchar — 알림 유형
  • created_date (Field3) — datetime — 알림 생성 시간

refresh_token (Untitled7)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (아이디) — bigint — Foreign key → student.id — NOT NULL
  • token (Field) — varchar — 토근 값

student (buddy)

  • id (아이디) — bigint — Primary key — NOT NULL
  • university (Field) — varchar — 대학교
  • korean (한국인 여부) — bit — 한국인 여부
  • nickname (닉네임) — varchar — 닉네임
  • major (학과) — varchar — 전공
  • gender (성별) — varchar — 성별
  • country (출신 국가) — varchar — 국적
  • certificated (대학생 인증여부) — bit — 학생 인증 여부
  • match_status (Field2) — varchar — 매칭 상태

student_interest (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (Key2) — bigint — Foreign key → interest.id — NOT NULL
  • interest_id (아이디) — bigint — Foreign key → student.id — NOT NULL

student_language (language_buddy)

  • id (아이디) — bigint — Primary key — NOT NULL
  • student_id (아이디2) — bigint — Foreign key → language.id — NOT NULL
  • language_id (아이디3) — bigint — Foreign key → student.id — NOT NULL