sns

Tables (8)

Untitled

    chat_message (채팅메시지)

    • id (PK) — Primary key — NOT NULL
    • room_id (index1) — Foreign key → chat_room.id — NOT NULL
    • participant_id (index2) — Foreign key → chat_participant.id — NOT NULL

    chat_participant (단톡 참석자)

    • id (PK) — Primary key — NOT NULL
    • user_id (index1) — Foreign key → users.id — NOT NULL
    • room_id (index2) — Foreign key → chat_room.id — NOT NULL

    chat_room (단톡방)

    • id (PK) — Primary key — NOT NULL
    • user_id (index) — Foreign key → users.id — NOT NULL

    comment (댓글)

    • id (PK) — Primary key — NOT NULL
    • post_id (index1) — Foreign key → posts.id — NOT NULL
    • user_id (index2) — Foreign key → users.id — NOT NULL

    end_room (종료된 방)

    • id (PK) — Primary key — NOT NULL
    • room_id (index) — Foreign key → chat_room.id — NOT NULL

    posts (게시글)

    • id (PK) — Primary key — NOT NULL
    • user_id (index) — Foreign key → users.id — NOT NULL

    users (회원)

    • id (PK) — Primary key — NOT NULL