ㅅㄷㄴㅅ
Tables (6)
Chats
- id — ObjectId
- postId — ObjectId — NOT NULL
- postTitle — VARCHAR(100)
- authorId — ObjectId — NOT NULL
- userId — ObjectId — NOT NULL
- lastMessage — TEXT
- lastMessageAt — DATETIME
- unreadCount_author — INT
- unreadCount_user — INT
- contractId — ObjectId
- isActive — BOOLEAN
- createdAt — DATETIME
- updatedAt — DATETIME
Contracts
- id — ObjectId
- chatId — ObjectId — NOT NULL
- postId — ObjectId — NOT NULL
- postTitle — VARCHAR(100)
- authorId — ObjectId — NOT NULL
- authorName — VARCHAR(50)
- userId — ObjectId — NOT NULL
- userName — VARCHAR(50)
- workDate — DATE
- workStartTime — VARCHAR(10)
- workEndTime — VARCHAR(10)
- salary — INT
- paymentDate — DATE
- workDescription — TEXT
- specialNotes — TEXT
- authorSignedAt — DATETIME
- userSignedAt — DATETIME
- isSigned — BOOLEAN
- createdAt — DATETIME
- updatedAt — DATETIME
Messages
- id — ObjectId
- chatId — ObjectId — NOT NULL
- senderId — ObjectId — NOT NULL
- senderName — VARCHAR(50)
- messageType — VARCHAR(20) — NOT NULL
- text — TEXT
- contractId — ObjectId
- accountNumber — VARCHAR(50)
- paymentComplete — BOOLEAN
- reviewId — ObjectId
- isRead — BOOLEAN
- readAt — DATETIME
- createdAt — DATETIME
Posts
- id — ObjectId
- authorId — ObjectId — NOT NULL
- type — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT
- location — VARCHAR(100)
- price — INT
- priceType — VARCHAR(10)
- category — VARCHAR(50)
- workDate — DATE
- workStartTime — VARCHAR(10)
- workEndTime — VARCHAR(10)
- workDuration — VARCHAR(20)
- images — VARCHAR(255)
- status — VARCHAR(20)
- completedWith — ObjectId
- viewCount — INT
- createdAt — DATETIME
- updatedAt — DATETIME
Reviews
- id — ObjectId
- postId — ObjectId — NOT NULL
- postTitle — VARCHAR(100)
- chatId — ObjectId — NOT NULL
- contractId — ObjectId
- reviewerId — ObjectId — NOT NULL
- reviewerName — VARCHAR(50)
- reviewerAvatar — VARCHAR(255)
- targetId — ObjectId — NOT NULL
- targetName — VARCHAR(50)
- reviewType — VARCHAR(20)
- rating — INT
- comment — TEXT — EX
- createdAt — DATETIME
Users
- id — ObjectId
- email — VARCHAR(100)
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50)
- type — VARCHAR(20) — NOT NULL
- avatar — VARCHAR(255)
- businessNumber — VARCHAR(20)
- businessName — VARCHAR(100)
- averageRating — DECIMAL(2,1)
- reviewCount — INT
- createdAt — DATETIME
- updatedAt — DATETIME