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