MZ 스나이퍼
테이블 (6)
Category
- Category ID (id) — number — 기본 키
- Meeting ID (meetingId) — number
- Name (name) — varchar
- Access (access) — varchar
- Introduce (introduce) — varchar
- Status (status) — varchar
- Create Date (createDate) — date
- Update Date (update) — date
- Create ID (createId) — number
- Update ID (updateId) — number
Category Member (CategoryMember)
- Category ID (categoryId) — number
- Member ID (memberId) — number
- Role (role) — enum
- Status (status) — varchar
- Create Date (createDate) — date
- Update Date (updateDate) — date
- Create ID (createId) — number
- Update ID (updateId) — number
Chat
- Chat ID (id) — number — 기본 키 — NOT NULL
- Member1 ID (memberId1) — number
- Member2 ID (memberId2) — number
MEMBER (Member)
- Member ID (id) — number — 기본 키 — NOT NULL
- Email (email) — varchar
- Name (name) — varchar
- Nick Name (nickname) — varchar
- Birthday (birthday) — date
- Status (status) — varchar
- Phone (phone) — number
- Profile Image (profileImage) — number
- Role (role) — enum
- Address (adress) — varchar
- Introduce (introduce) — varchar
- Create Date (createDate) — date
- Update Date (updateDate) — date
- Create ID (createId) — number
- Update ID (updateId) — number
Meeting (Meet)
- Meeting ID (id) — number — 기본 키 — NOT NULL
- Master (master) — number
- Name (name) — varchar
- Member Max (memberMax) — number
- Access (access) — varchar
- Introduce (introduce) — varchar
- Status (status) — varchar
- Create Date (createDate) — date
- Update Date (updateDate) — date
- Create ID (createId) — number
- Update ID (updateId) — number
Meeting Member (MeetingMember)
- Meeting ID (meetingId) — number
- Member ID (memberId) — number
- Role (role) — enum
- Status (status) — varchar
- Create Date (createDate) — date
- Update Date (updateDate) — date
- Create ID (createId) — number
- Update ID (updateId) — number