다이렉트 메시지
테이블 (25)
Copy Of agree (CopyOfagree)
- id — NOT NULL — 기본 키 — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
alert
- id — NOT NULL — 기본 키 — NOT NULL
- sender_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- receiver_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- type — NOT NULL
- is_read — NOT NULL
- content — NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
avatar
- id — NOT NULL — 기본 키 — NOT NULL
- user_id — NOT NULL — 외래 키 → user.id — NOT NULL
- sex — NOT NULL
- birthday — NOT NULL
- mbti — NULL
- picture — NOT NULL
- nickname — NOT NULL
- introduce — NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
block
- id — NOT NULL — 기본 키 — NOT NULL
- sender_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- receiver_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- created_at — NOT NULL
- deleted_at — NULL
entity_type
- id — NOT NULL — 기본 키 — NOT NULL
- entity_name — NOT NULL
- notificatino_description (notification_description) — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
entity_type_test
- id — NOT NULL — 기본 키 — NOT NULL
- entity_name — NOT NULL
- notificatino_description (notification_description) — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
firewall
- id — NOT NULL — 기본 키 — NOT NULL
- phone — NULL
- email (eamil) — NULL
- authcode — NULL
- count — NOT NULL
- defend — NOT NULL
- approach_time — NOT NULL
friendship_status_test
- id — NOT NULL — 기본 키 — NOT NULL
- discription — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- updated_at — NOT NULL
friendship_test
- id — NOT NULL — 기본 키 — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- updated_at — NOT NULL
- sender_id — NOT NULL — 외래 키 → user_test.id — NOT NULL
- receiver_id — NOT NULL — 외래 키 → user_test.id — NOT NULL
- friendship_status_id — NOT NULL — 외래 키 → friendship_status_test.id — NOT NULL
message
- id — NOT NULL — 기본 키 — NOT NULL
- sender_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- state — NOT NULL
- created_at — NOT NULL
- room_id — NOT NULL — 외래 키 → room.id — NOT NULL
notification (_)
- id — NOT NULL — 기본 키 — NOT NULL
- notification_object_id — NOT NULL — 외래 키 → notification_object.id — NOT NULL
- is_readed — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NOT NULL
notification_change
- id — NOT NULL — 기본 키 — NOT NULL
- notification_object_id — NOT NULL — 외래 키 → notification_object.id — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
notification_object
- id (Key) — NOT NULL — 기본 키 — NOT NULL
- entity_type_id — NOT NULL — 외래 키 → entity_type.id — NOT NULL
- entity_id — NOT NULL
notification_object_test
- id (Key) — NOT NULL — 기본 키 — NOT NULL
- entity_type_id — NOT NULL — 외래 키 → entity_type_test.id — NOT NULL
- entity_id — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
notification_test
- id — NOT NULL — 기본 키 — NOT NULL
- is_readed — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NOT NULL
- notification_object_id — NOT NULL — 외래 키 → notification_object_test.id — NOT NULL
- notifier_id — NOT NULL — 외래 키 → user_test.id — NOT NULL
notificaton_chage_test
- id — NOT NULL — 기본 키 — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
- notification_object_id — NOT NULL — 외래 키 → notification_object_test.id — NOT NULL
- actor_id — NOT NULL — 외래 키 → user_test.id — NOT NULL
relship
- id — NOT NULL — 기본 키 — NOT NULL
- receiver_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- sender_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- state — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- udpated_at — NOT NULL
report
- id — NOT NULL — 기본 키 — NOT NULL
- receiver_id — NOT NULL — 외래 키 — NOT NULL
- sender_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- reason — NULL
- state — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NULL
room
- id — NOT NULL — 기본 키 — NOT NULL
- sender_relsihp_id (id2) — NOT NULL — 외래 키 → relship.id — NOT NULL
- receiver_relship_id (id3) — NOT NULL — 외래 키 → relship.id — NOT NULL
room_alter
- id — NOT NULL — 기본 키 — NOT NULL
- relship_id — NOT NULL — 외래 키 → relship.id — NOT NULL
- avatar_id — NOT NULL — 외래 키 → avatar.id — NOT NULL
- state — NOT NULL
tag
- id — NOT NULL — 기본 키 — NOT NULL
- tag_kind_id — NOT NULL — 외래 키 → tag_kind.id — NOT NULL
- content — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- updated_at — NULL
tag_kind (tag_status)
- id — NOT NULL — 기본 키 — NOT NULL
- description — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- updated_at — NULL
tagging
- id — NOT NULL — 기본 키 — NOT NULL
- tag_id — NOT NULL — 외래 키 → tag.id — NOT NULL
- created_at — NOT NULL
- deleted_at — NOT NULL
- updated_at — NULL
user
- id — NOT NULL — 기본 키 — NOT NULL
- uid — NOT NULL
- password — NOT NULL
- email — NULL
- role — NOT NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NOT NULL
- is_ban — NOT NULL
- banded_at — NULL
- unbanded_at — NULL
user_test
- id — NOT NULL — 기본 키 — NOT NULL
- username — NULL
- created_at — NOT NULL
- updated_at — NOT NULL
- deleted_at — NOT NULL