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 (멤버탈퇴여부)