校园资料分享平台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