DriveU-ERD

Tables (10)

Untitled

    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