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