예시

테이블 (3)

chatRoom (Untitled2)

  • room_idx (Key) — int — 기본 키 — NOT NULL
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp

member (Untitled)

  • member_idx (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(25)
  • email (Field2) — varchar(25)
  • password (Field3) — varchar(100)
  • created_at (Field4) — timestamp
  • update_at (Field5) — timestamp

member_chatRoom (Untitled3)

  • member_idx (Key) — int — 외래 키 → member.member_idx — NOT NULL
  • room_idx (Key2) — int — 외래 키 → chatRoom.room_idx — NOT NULL
  • join_at (Field) — timestamp