DriveU-ERD
Tables (10)
ai_summary
- id — BIGINT
- file_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
directories
- id — BIGINT
- semester_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- name — VARCHAR — NOT NULL
- type — BOOLEAN — NOT NULL
- order — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
directory_hierarchy
- ancestor_id — BIGINT — Primary key — NOT NULL
- descendant_id — BIGINT — Primary key — NOT NULL
- depth — INTEGER — NOT NULL
file_tags
- id — BIGINT
- file_id — BIGINT — NOT NULL
- tag_id — BIGINT — NOT NULL
files
- id — BIGINT
- user_id — BIGINT — NOT NULL
- directory_id — BIGINT — NOT NULL
- title — VARCHAR — NOT NULL
- s3_path — VARCHAR — NOT NULL
- extension — VARCHAR — NOT NULL
- size — BIGINT — NOT NULL
- is_favorite — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
links
- id — BIGINT
- user_id — BIGINT — NOT NULL
- directory_id — BIGINT — NOT NULL
- url — VARCHAR — NOT NULL
- icon_type — VARCHAR
- is_favorite — BOOLEAN — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
semesters
- id — BIGINT — Primary key
- user_id — BIGINT — NOT NULL
- year — INTEGER — NOT NULL
- term — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
tags
- id — BIGINT
- user_id — BIGINT — NOT NULL
- type — VARCHAR — NOT NULL
- name — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGINT — Primary key
- name — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL
- provider — VARCHAR — NOT NULL
- created_at — TIMESTAMP — NOT NULL