shBlog
Tables (5)
Blog (블로그)
- blog_id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(255) — NOT NULL
- intro (Field2) — VARCHAR(255)
- banner_image_url (Field3) — VARCHAR(255)
- created_at (Field4) — DATETIME — NOT NULL
- updated_at (Field5) — DATETIME
- user_id (사용자 ID) — BIGINT — Foreign key → User.user_id — NOT NULL
Category (Untitled)
- category_id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- description (Field2) — VARCHAR(255)
- blog_id (Key2) — BIGINT — Foreign key → Blog.blog_id — NOT NULL
- parent_id (Key3) — BIGINT — Foreign key → Category.category_id
- Field3
Post (Untitled2)
- post_id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- content (Field2) — TEXT
- is_public (Field3) — BOOLEAN — NOT NULL
- created_at (Field4) — DATETIME — NOT NULL
- updated_at (Field5) — DATETIME
- blog_id (Key2) — BIGINT — Foreign key → Blog.blog_id — NOT NULL
- category_id (Key3) — BIGINT — Foreign key → Category.category_id — NOT NULL
UploadFile (Untitled3)
- upload_file_id (Key) — BIGINT — Primary key — NOT NULL
- type (Field) — VARCHAR(255) — NOT NULL
- object_name (Field2) — VARCHAR(1024) — NOT NULL
- url (Field3) — VARCHAR(2048) — NOT NULL
- status (Field4) — VARCHAR(255) — NOT NULL
- created_at (Field5) — DATETIME — NOT NULL
- updated_at (Field6) — DATETIME
- deleted_at (Field7) — DATETIME
- user_id (사용자 ID) — BIGINT — Foreign key → User.user_id — NOT NULL
- post_id (Key2) — BIGINT — Foreign key → Post.post_id — NOT NULL
User (사용자)
- user_id (사용자 ID) — BIGINT — Primary key — NOT NULL
- username (Field) — VARCHAR(255)
- password (Field2) — VARCHAR(255) — NOT NULL
- nickname (Field3) — VARCHAR(255)
- email (Field4) — VARCHAR(255)
- profile_image_url (Field5) — VARCHAR(255)
- role (Field6) — VARCHAR(255)
- created_at (Field7) — DATETIME — NOT NULL
- updated_at (Field8) — DATETIME