校园资料分享平台er图

Tables (7)

categories

  • id — BIGINT
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)
  • icon — VARCHAR(50)
  • sort_order — INT — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

comments

  • id — BIGINT
  • content — TEXT — NOT NULL
  • resource_id — BIGINT — Foreign key → resources.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • parent_id — BIGINT — Foreign key → comments.id
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

download_records

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • resource_id — BIGINT — Foreign key → resources.id — NOT NULL
  • downloaded_at — DATETIME — NOT NULL

favorites

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • resource_id — BIGINT — Foreign key → resources.id — NOT NULL
  • created_at — DATETIME — NOT NULL

resource_likes

  • id — BIGINT
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • resource_id — BIGINT — Foreign key → resources.id — NOT NULL
  • created_at — DATETIME — NOT NULL

resources

  • id — BIGINT
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category_id — BIGINT — Foreign key → categories.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • file_name — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • file_type — VARCHAR(50)
  • status — VARCHAR(20) — NOT NULL
  • download_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL
  • favorite_count — INT — NOT NULL
  • points — INT — NOT NULL
  • course — VARCHAR(50)
  • semester — VARCHAR(50)
  • teacher — VARCHAR(50)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

users

  • id — BIGINT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • college — VARCHAR(50)
  • major — VARCHAR(50)
  • avatar — VARCHAR(255)
  • points — INT — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • enabled — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME