catchat-classNonetoone

Tables (3)

Untitled

    member

    • 식별자 (id) — bigint — Primary key — NOT NULL
    • 이메일 (email) — varchar(100)
    • 비밀번호 (password) — varchar(255)
    • 별명 (nickname) — varchar(50)
    • 성별 (gender) — varchar(10)
    • 프로필URL (profile_image_url) — varchar(255)

    one_to_one_chat_room (chat_room)

    • 식별자 (room_id) — Primary key — NOT NULL
    • Field
    • 식별자 (id2) — bigint — Foreign key → member.식별자 — NOT NULL
    • 식별자 (id3) — bigint — Foreign key → member.식별자 — NOT NULL