다이렉트 메시지

테이블 (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