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