tmp

Tables (7)

Untitled

    article_images

    • id — INT — Primary key — NOT NULL
    • url — VARCHAR(300)
    • upload_time — DATETIME — NOT NULL
    • articles_id — INT — Foreign key → articles.id — NOT NULL
    • INDEX — `fk_article_images_articles1_idx`

    article_likes

    • id — INT — Primary key — NOT NULL
    • article_like_time — DATETIME — NOT NULL
    • articles_id — INT — Foreign key → articles.id — NOT NULL
    • users_email_id — VARCHAR(50) — Foreign key → users.email_id — NOT NULL
    • INDEX — `fk_article_likes_articles1_idx`
    • INDEX — `fk_article_likes_users1_idx`

    articles

    • id — INT — Primary key — NOT NULL
    • content — VARCHAR(50)
    • upload_time — DATETIME — NOT NULL
    • private_flag — INT
    • users_email_id — VARCHAR(50) — Foreign key → users.email_id — NOT NULL
    • INDEX — `fk_articles_users_idx`

    comment_likes

    • id — INT — Primary key — NOT NULL
    • time — DATETIME — NOT NULL
    • comments_id — INT — Foreign key → comments.id — NOT NULL
    • users_email_id — VARCHAR(50) — Foreign key → users.email_id — NOT NULL
    • INDEX — `fk_comment_likes_comments1_idx`
    • INDEX — `fk_comment_likes_users1_idx`

    comments

    • id — INT — Primary key — NOT NULL
    • parent_comment_id — INT — NOT NULL
    • content — VARCHAR(500) — NOT NULL
    • upload_time — DATETIME
    • articles_id — INT — Foreign key → articles.id — NOT NULL
    • users_email_id — VARCHAR(50) — Foreign key → users.email_id — NOT NULL
    • INDEX — `fk_comments_articles1_idx`
    • INDEX — `fk_comments_users1_idx`

    users

    • email_id — VARCHAR(50) — Primary key — NOT NULL
    • email_password — VARCHAR(200)
    • nickname — VARCHAR(50) — NOT NULL
    • provider — VARCHAR(50)
    • identifier — VARCHAR(50)
    • role — VARCHAR(10) — NOT NULL
    • refresh_token — VARCHAR(300)
    • sign_in_time — DATETIME
    • sign_up_time — DATETIME — NOT NULL