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