Uniting_ERD

Tables (15)

ChatMessage (Untitled10)

  • id (KEY) — Primary key
  • room_id (FK) — Primary key
  • sender_id (FK1) — Primary key
  • message (Field4)
  • message_type (Field5)
  • created_at (Field6)
  • read_count (Field7)

ChatRoom (Untitled9)

  • ID (KEY) — Primary key
  • match_id (FK) — Primary key
  • created_at (Field3)

Department (Untitled2)

  • department_id (Key) — Primary key — NOT NULL
  • school_id (FK) — Primary key — NOT NULL
  • name (Field3)

Image (Untitled3)

  • image_id (Key) — Primary key — NOT NULL
  • url (Field2)
  • type (Field3)
  • upload_at (Field4)

LocationVerification (Untitled8)

  • id (KEY) — Primary key
  • meeting_id (FK) — Primary key
  • user_id (FK1) — Primary key
  • verified (Field4)
  • verified_time (Field5)
  • distance (Field6)

Match (Untitled6)

  • id (KEY) — Primary key
  • male_team_id (FK) — Primary key
  • female_team_id (FK1) — Primary key
  • status (Field4)
  • matching_type (Field5)
  • created_at (Field6)

Meeting (Untitled7)

  • id (KEY) — Primary key
  • match_id (FK) — Primary key
  • meeting_date (Field3)
  • meeting_time (Field4)
  • place_name (Field5)
  • address (Field6)
  • latitude (Field7)
  • longitude (Field8)
  • status (Field9)

Penalty (Untitled13)

  • id (KEY) — Primary key
  • user_id (FK) — Primary key
  • reason (Field3)
  • start_date (Field4)
  • end_date (Field5)
  • created_at (Field6)

Review (Untitled11)

  • id (KEY) — Primary key
  • match_id (FK) — Primary key
  • reviewer_id (FK1) — Primary key
  • target_id (FK2) — Primary key
  • rating (Field5)
  • manner (Field6)
  • conversation (Field7)
  • promise (Field8)
  • comment (Field9)
  • look_tag_match (Field10)
  • status (Field11)
  • created_at (Field12)

ReviewReport (Untitled12)

  • id (KEY) — Primary key
  • review_id (FK) — Primary key
  • reporter_id (FK1) — Primary key
  • reason (Field4)
  • status (Field5)

School (CopyOfUntitled)

  • school_id (Key) — Primary key — NOT NULL
  • name (Field2)
  • region (Field3)
  • email_domain (Field4)
  • created_at (Field5)
  • Field

Team (Untitled4)

  • id (PK) — Primary key
  • leader_id (FK) — Primary key
  • team_image_id (FK1) — Primary key — NOT NULL
  • gender (Field3)
  • title (Field4)
  • description (Field5)
  • max_member (Field6)
  • current_member (Field7)
  • status (Field8)
  • created_at (Field9)

TeamMember (Untitled5)

  • team_id (FK) — Primary key
  • user_id (FK1) — Primary key
  • role (Field3)
  • joined_at (Field4)

TicketHistory (Untitled14)

  • id (KEY) — Primary key
  • user_id (FK) — Primary key
  • type (Field3)
  • amount (Field4)
  • reason (Field5)
  • created_at (Field6)

USER (Untitled)

  • ID (Key) — Primary key — NOT NULL
  • school_id (FK) — Primary key — NOT NULL
  • department_id (FK1) — Primary key — NOT NULL
  • profile_image_id (FK2) — Primary key
  • face_image_id (FK3) — Primary key
  • email (Field3)
  • password (Field4)
  • real_name (Field5)
  • nick_name (Field6)
  • gender (Field7)
  • student_number (Field8)
  • admission_year (Field9)
  • introduction (Field12)
  • average_rating (Field13)
  • review_count (Field14)
  • ticket_count (Field15)
  • status (Field16)
  • created_at (Field17)