sendtime-assignment

Tables (4)

GROUP

  • GROUP_ID (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • NAME (그룹이름)
  • CREATED_AT (그룹생성날짜)
  • UPDATED_AT (그룹수정날짜)
  • IS_REMOVED (그룹삭제여부)

GROUP_INVITATION (INVITATION)

  • INVITATION_ID (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • CODE (초대링크코드)
  • INVITATION_TYPE (초대형태타입)
  • IS_EXPIRED (만료여부)
  • EXPIRED_AT (만료시간)

GROUP_PARTICIPANT

  • GROUP_PARTICIPANT_ID (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • MEMBER_ID (Key2) — AUTO_INCREMENT — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • GROUP_ID (Key3) — AUTO_INCREMENT — Foreign key → GROUP.GROUP_ID — NOT NULL
  • INVITATION_ID (Key4) — AUTO_INCREMENT — Foreign key → GROUP_INVITATION.INVITATION_ID — NOT NULL
  • CREATED_AT (그룹참여날짜)
  • IS_REMOVED (그룹참여삭제여부)
  • ROLE (그룹역할)

MEMBER

  • MEMBER_ID (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • NAME (멤버이름)
  • PHONE (전화번호)
  • EMAIL (이메일)
  • CREATED_AT (멤버생성날짜)
  • UPDATED_AT (멤버수정날짜)
  • IS_REMOVED (멤버삭제여부)
  • EXPIRED_AT (멤버탈퇴여부)