EnterProjectBack
Tables (6)
Authentications (Untitled)
- id (Key) — Primary key — NOT NULL
CahtRooms (채팅방)
- id (Key) — string — Primary key — NOT NULL
- first_user_id (Field) — bigint
- second_user_id (Field2) — bigint
- identifier (Field3) — string
- chat_messages (Field4) — array
- Field5
Notifications (공지사항)
- id (key) — bigint — Primary key — NOT NULL
- user_id (fk) — bigint — Foreign key → Users.id — NOT NULL
- notification_type (Field) — int
- identifier (Field2) — varchar(50)
- is_read (Field3) — boolean
- is_valid (Field4) — boolean
- creat_at (Field5) — timestamp
Participants (참가자)
- id (Key) — string — Primary key — NOT NULL
- chat_room_id (key2) — bigint
- user_id (Field) — bigint
- out (Field2) — boolean
- read_message_size (Field3) — bigint
- create_at (F) — timestamp
- update_dt (Field4) — timestamp
- Field5
Users (사용자)
- id (Key) — bigint — Primary key — NOT NULL
- oauth_id (Field) — bigint
- nickname (Field2) — varchar(20)
- profile_url (Field3) — varchar(250)
- password (Field6) — varchar(128)
- email (Field7) — varchar(128)
- create_at (Field4) — timestamp
- update_at (Field5) — timestamp