post-service

Tables (5)

PostImageUrls (Untitled5)

  • post_image_id (Key2) — Primary key — NOT NULL
  • post_id (Key) — Foreign key → post.post_id — NOT NULL
  • image_url (Field)

admin_code (Untitled4)

  • admin_code_id (Key) — index — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • requset_code (Field) — index
  • invited_user_id (Key3) — Foreign key → user.user_id — NOT NULL
  • expired_at (Field2)

comment (Untitled3)

  • comment_id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → post.post_id — NOT NULL
  • body (Field)
  • image_url (Field2)
  • is_hidden (Field3)
  • deleted_at (Field4)
  • created_at (Field5)
  • updated_at (Field6)
  • deleted_reason (Field7)
  • is_pinned (Field8)

post (Untitled2)

  • post_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.user_id — NOT NULL
  • title (Field)
  • content (Field2)
  • is_hidden (Field4)
  • deleted_at (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • deleted_reason (Field8)
  • is_ announcement (Field9)
  • is_pinned (Field10)

user (Untitled)

  • user_id (Key) — Primary key — NOT NULL
  • email (Field)
  • role (Field3) — index
  • password (Field4)
  • parent_admin_user_id (Field5)
  • image_url (Field6)