GDSC_DEVLOG
Tables (4)
article (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- content (Field2) — VARCHAR(50000) — NOT NULL
- like_count (Field4) — INTEGER — NOT NULL
- thumbnail_url (Key2) — VARCHAR(256) — NOT NULL
- created_at (Field3) — TIMESTAMP — NOT NULL
- updated_at (Field5) — TIMESTAMP
tag (Untitled2)
- id (Key) — Primary key — NOT NULL
- name (Field)
taglist (Untitled3)
- article_id (Key) — BIGINT — Foreign key → article.id — NOT NULL
- tag_id (Key2) — Foreign key → tag.id — NOT NULL
view_log (Untitled4)
- article_id (Key2) — BIGINT — Foreign key → article.id — NOT NULL
- timestamp (Key) — TIMESTAMP — NOT NULL
- ip_address (Key3) — CHAR(15) — NOT NULL