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