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)