tmp
Tables (7)
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