SchoolBoard
Tables (5)
CourseSubject (Untitled)
- cs_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
- sub_id (Key3) — BIGINT — Foreign key → subject.sub_id — NOT NULL
department (Untitled3)
- dept_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field2) — VARCHAR(255)
- created_at (Field) — TIMESTAMP
- modified_at (Field3) — TIMESTAMP
post (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- dept_id (Key3) — BIGINT — Foreign key → department.dept_id — NOT NULL
- sub_id (Key4) — BIGINT — Foreign key → subject.sub_id — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
- title (Field) — VARCHAR(255)
- content (Field6) — VARCHAR(255)
- status (Field3) — VARCHAR(255)
- view_count (Field4) — BIGINT
- created_at (Field2) — TIMESTAMP
- modified_at (Field5) — TIMESTAMP
subject (Untitled5)
- sub_id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.user_id — NOT NULL
- name (Field) — VARCHAR(255)
- created_at (Field2) — TIMESTAMP
- modified_at (Field3) — TIMESTAMP
user (Untitled6)
- user_id (Key) — BIGINT — Primary key — NOT NULL
- sub_id (Key2) — BIGINT — Foreign key → subject.sub_id — NOT NULL
- dept_id (Key3) — BIGINT — Foreign key → department.dept_id — NOT NULL
- name (Field) — VARCHAR(255)
- address (Field2) — VARCHAR(255)
- phone_no (Field3) — VARCHAR(255)
- birth (Field4) — DATE
- user_type (Field5) — VARCHAR(255)
- created_at (Field6) — TIMESTAMP
- modified_at (Field7) — TIMESTAMP