Chatting App

Tables (6)

Chat (채팅 메시지)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

Chat Room (채팅방)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6

Follow (친구 신청)

  • id (PK) — Long — Primary key — NOT NULL
  • request_id (FK) — Long — Foreign key → User.id — NOT NULL
  • respond_id (FK1) — Long — Foreign key → User.id — NOT NULL
  • wait (Field) — boolean

Notice List (알림 목록)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

Schedule (유저 스케줄 알람)

  • id (Key) — Long — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

User (유저)

  • id (PK) — Long — Primary key — NOT NULL
  • user_id (Field) — varchar
  • password (Field2) — varchar
  • nickname (Field3) — varchar
  • friends (Field4) — List