kaco

Tables (5)

Untitled

    comments (Untitled4)

    • id (Key) — BIGINT — Primary key — NOT NULL
    • post_id (Key2) — BIGINT — Foreign key → posts.id — NOT NULL
    • user_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
    • content (Field3) — TEXT
    • created_at (Field4) — DATETIME
    • updated_at (Field5) — DATETIME

    post_likes (Untitled5)

    • id (Key) — BIGINT — Primary key — NOT NULL
    • post_id (Key2) — BIGINT — Foreign key → posts.id — NOT NULL
    • user_id (Key3) — BIGINT — Foreign key → users.id — NOT NULL
    • created_at (Field3) — DATETIME

    posts (Untitled3)

    • id (Key) — BIGINT — Primary key — NOT NULL
    • user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
    • title (Field2) — VARCHAR(200)
    • content (Field3) — TEXT
    • created_at (Field4) — DATETIME
    • updated_at (Field5) — DATETIME

    users (Untitled2)

    • id (Key) — BIGINT — Primary key — NOT NULL
    • email (Field) — VARCHAR(100)
    • password (Field2) — VARCHAR(255)
    • nickname (Field3) — VARCHAR(50)
    • profile_image (Field4) — VARCHAR(255)
    • created_at (Field5) — DATETIME
    • updated_at (Field6) — DATETIME