Buddys

Tables (13)

ChatMessage (Untitled19)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • message (Field) — VARCHAR(2000) — NOT NULL
  • created_at (Field2) — DATETIME — NOT NULL
  • sender_id (Key2) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL
  • chat_room_id (Key3) — BIGINT UNSIGNED — Foreign key → ChatRoom.id — NOT NULL

ChatRoom (Untitled17)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • created_at (Field) — DATETIME — NOT NULL

ChatRoomMember (Untitled18)

  • user_id (사용자 ID) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL
  • chat_room_id (채팅방 ID) — BIGINT UNSIGNED — Foreign key → ChatRoom.id — NOT NULL
  • joined_at (참여 일시) — DATETIME — NOT NULL
  • last_read_at (마지막 조회 일시) — DATETIME

City (Untitled3)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • name (Field) — VARCHAR — NOT NULL
  • country_id (Key2) — BIGINT UNSIGNED — Foreign key → Country.id — NOT NULL

Comment (댓글)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • content (Field) — VARCHAR(1000) — NOT NULL
  • createdAt (Field2) — DATETIME — NOT NULL
  • updatedAt (Field3) — DATETIME
  • deletedAt (Field4) — DATETIME
  • postId (Key2) — BIGINT UNSIGNED — Foreign key → Post.id — NOT NULL
  • authorId (Key3) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL

Country (Untitled2)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • name (Field) — VARCHAR(80) — NOT NULL
  • continent (Field2) — ENUM — NOT NULL

Post (Untitled10)

  • id (ㅇ) — BIGINT — Primary key — NOT NULL
  • continent (Field) — ENUM
  • title (Field2) — VARCHAR(120) — NOT NULL
  • content (Field3) — TEXT — NOT NULL
  • startDate (Field4) — DATE
  • endDate (Field5) — DATE
  • recruitCount (모집 인원) — TINYINT UNSIGNED — NOT NULL
  • minAge (Field7) — TINYINT UNSIGNED
  • maxAge (Field8) — TINYINT UNSIGNED
  • genderCondition (Field9) — ENUM — NOT NULL
  • isCompleted (Field10) — TINYINT(1) — NOT NULL
  • viewCount (Field11) — INT UNSIGNED — NOT NULL
  • createdAt (Field12) — DATETIME — NOT NULL
  • updatedAt (Field13) — DATETIME
  • deletedAt (Field14) — DATETIME
  • authorId (Key2) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL
  • countryId (Key3) — BIGINT UNSIGNED — Foreign key → Country.id — NOT NULL
  • cityId (Key4) — BIGINT UNSIGNED — Foreign key → City.id

PostBookmark (Untitled16)

  • userId (Key) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL
  • postId (Key2) — BIGINT UNSIGNED — Foreign key → Post.id — NOT NULL
  • createdAt (Field) — DATETIME — NOT NULL

PostImage (Untitled11)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • image_url (Field) — VARCHAR(512) — NOT NULL
  • order_no (Field2) — TINYINT UNSIGNED — NOT NULL
  • postId (Key2) — BIGINT UNSIGNED — Foreign key → Post.id — NOT NULL

PostTag (Untitled14)

  • post_id (Key) — BIGINT UNSIGNED — Foreign key → Post.id — NOT NULL
  • tag_id (Key2) — BIGINT UNSIGNED — Foreign key → Tag.id — NOT NULL

Tag (Untitled6)

  • id (Key) — BIGINT UNSIGNED — Primary key — NOT NULL
  • name (Field) — VARCHAR(30) — NOT NULL
  • tag_type (Field2) — ENUM — NOT NULL

User (사용자)

  • id (사용자 ID) — BIGINT UNSIGNED — Primary key — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • provider (로그인 제공자) — ENUM — NOT NULL
  • providerId (OAuth 식별자) — VARCHAR(255) — NOT NULL
  • nickname (닉네임) — VARCHAR(30) — NOT NULL
  • profileImageUrl (프로필 이미지 URL) — VARCHAR(512)
  • introduction (한줄 소개) — VARCHAR(150)
  • birthDate (생년월일) — DATE
  • gender (성별) — ENUM
  • notification_enabled (알림 수신 여부) — TINYINT(1) — NOT NULL
  • account_status (계정 상태) — ENUM — NOT NULL
  • exchange_country_id (파견 국가) — BIGINT UNSIGNED — Foreign key → Country.id
  • exchange_university (파견 대학) — VARCHAR(100)
  • exchange_start_date (파견 시작일) — DATE
  • exchange_end_date (파견 종료일) — DATE
  • created_at (생성일시) — DATETIME — NOT NULL
  • updated_at (수정일시) — DATETIME
  • deleted_at (삭제일시) — DATETIME

UserTag (Untitled9)

  • user_id (Key) — BIGINT UNSIGNED — Foreign key → User.id — NOT NULL
  • tag_id (Key2) — BIGINT UNSIGNED — Foreign key → Tag.id — NOT NULL
  • created_at (Field) — DATETIME — NOT NULL