gotaku

Tables (10)

Category (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • category_name (Field)

Comment (Untitled7)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.id — NOT NULL
  • user_id (id) — Foreign key → User.id — NOT NULL
  • comment_body (Field)
  • is_deleted (Field2)

Comment Like (Untitled8)

  • Key — Primary key — NOT NULL
  • comment_id (Key2) — Foreign key → Comment.id — NOT NULL
  • user_id (id) — Foreign key → User.id — NOT NULL

Post (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • category_id (Key2) — Foreign key → Category.id — NOT NULL
  • user_id (id) — Foreign key → User.id — NOT NULL
  • post_titile (Field)
  • post_body (Field2)
  • is_visible (Field4)
  • is_deleted (Field5)
  • created_at (Field6)
  • updated_at (Field7)
  • is_deleted (Field3)

Tag (Untitled9)

  • id (Key) — Primary key — NOT NULL
  • tag_name (Field)

User (Untitled)

  • id — Primary key — NOT NULL
  • image_id (Key) — Foreign key → image.id — NOT NULL
  • user_nickname (nickname) — string
  • short_bio
  • user_email (email)
  • is_certified
  • is_marketing_info_allowed (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • is_deleted (Field4)

image (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • image_url (Field)
  • is_deleted (Field2)

post_image_map (Untitled5)

  • id (Key2) — Primary key — NOT NULL
  • image_id (Key) — Foreign key → image.id — NOT NULL
  • post_id (Key3) — Foreign key → Post.id — NOT NULL

post_like (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.id — NOT NULL
  • user_id (id) — Foreign key → User.id — NOT NULL

post_tag_map (Untitled10)

  • id (Key) — Primary key — NOT NULL
  • post_id (Key2) — Foreign key → Post.id — NOT NULL
  • tag_id (Key3) — Foreign key → Tag.id — NOT NULL