mytalk
Tables (5)
ChatEntity (chat)
- chat_no (Key) — BIGINT — Primary key — NOT NULL
- user_no (Key2) — BIGINT — Foreign key → RoomUserEntity.user_no — NOT NULL
- room_no (Key22) — BIGINT — Foreign key → RoomUserEntity.room_no — NOT NULL
- Key3 — Foreign key → RoomUserEntity.room_user_no — NOT NULL
- chat_text (Field) — VARCHAR
- created_at (Field2) — DATETIME
FileEntity (file)
- file_no (Key) — BIGINT — Primary key — NOT NULL
- chat_no (Key2) — BIGINT — Foreign key → ChatEntity.chat_no — NOT NULL
- user_no (Key22) — BIGINT — Foreign key → ChatEntity.user_no — NOT NULL
- room_no (Key222) — BIGINT — Foreign key → ChatEntity.room_no — NOT NULL
- Key3 — Foreign key → ChatEntity.Key3 — NOT NULL
- original_name (Field) — VARCHAR
- saved_path (Field2) — VARCHAR
RoomEntity (room)
- room_no (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR
- description (Field2) — VARCHAR
- created_at (Field3) — DATETIME
- created_by (Field4) — BIGINT
RoomUserEntity (room_user)
- room_user_no (Key3) — BIGINT — Primary key — NOT NULL
- user_no (Key) — BIGINT — Foreign key → UserEntity.user_no — NOT NULL
- room_no (Key2) — BIGINT — Foreign key → RoomEntity.room_no — NOT NULL
UserEntity (user)
- user_no (Key) — BIGINT — Primary key — NOT NULL
- username (Field) — VARCHAR
- password (Field2) — VARCHAR