wnc

Tables (9)

career (Untitled3)

  • career_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • content (Field)
  • career_type (Field2)

category (Untitled5)

  • category_id (Key) — Primary key — NOT NULL
  • name (Field)

chat (Untitled8)

  • chat_id (Key2) — Primary key — NOT NULL
  • msg (Field)
  • createdAt (Field2)

chat_room (Untitled10)

  • chat_room_id (Key) — Primary key — NOT NULL
  • chat_id (Key2) — Foreign key → chat.chat_id — NOT NULL
  • user_id (Key3) — Foreign key → user.user_id — NOT NULL

group_student (Untitled6)

  • group_student_id (Key3) — Primary key — NOT NULL
  • group_id (Key) — Foreign key → groups.group_id — NOT NULL
  • student_id (Key2) — Foreign key → user.user_id — NOT NULL
  • is_evaluate (Field)
  • is_report (Field2)

groups (Untitled4)

  • group_id (Key) — Primary key — NOT NULL
  • teacher (Key2) — Foreign key → user.user_id — NOT NULL

notification (Untitled9)

  • notification_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • message (Field)

post (Untitled2)

  • post_id (Key) — Primary key — NOT NULL
  • author (Key2) — Foreign key → user.user_id — NOT NULL
  • category_id (Key3) — Foreign key → category.category_id — NOT NULL
  • group_id (Key4) — Foreign key → groups.group_id — NOT NULL
  • title (Field)
  • content (Field2)
  • post_type (Field10)
  • start_date (Field4)
  • end_date (Field5)
  • total_student_count (Field8)
  • applicant_count (Field7)
  • created_at (Field3)
  • updated_at (Field9)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • name (Field8)
  • password (Field2)
  • image_url (Field4)
  • role (Field3)
  • provider (Field5)
  • point (Field6)
  • voter_count (Field10)
  • ban_count (Field7)
  • is_baned (Field9)