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