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)