unithon-be
Tables (3)
EVENT (이벤트)
- id (고유 id) — VARCHAR(255) — Primary key — NOT NULL — UUID
- member_id (사용자 id) — VARCHAR(255) — Foreign key → MEMBER.id — NOT NULL — UUID
- content (이벤트 내용) — TEXT — NOT NULL
- occurred_at (대상 날짜) — VARCHAR(255) — NOT NULL
- created_at (생성일자) — VARCHAR(255) — NOT NULL
- last_modified_at (수정일자) — VARCHAR(255) — NOT NULL
MEMBER (사용자)
- id (고유 id) — VARCHAR(255) — Primary key — NOT NULL — UUID
- nickname (닉네임) — VARCHAR(255) — NOT NULL
- credential (apple 로그인 정보) — VARCHAR(255) — NOT NULL
- created_at (생성일자) — VARCHAR(255) — NOT NULL
- last_modified_at (수정일자) — VARCHAR(255) — NOT NULL
MESSAGE (메시지)
- id (고유 id) — VARHCAR(255) — Primary key — NOT NULL — UUID
- sender_id (발송인 id) — VARCHAR(255) — Foreign key → MEMBER.id — NOT NULL — UUID
- receiver_id (수신인 id) — VARCHAR(255) — Foreign key → MEMBER.id — NOT NULL — UUID
- receiver_name (발송인 이름) — VARCHAR(255) — NOT NULL
- content (내용) — TEXT — NOT NULL
- send_date_planned (발송 예정일자) — VARCHAR(255) — NOT NULL
- created_at (생성일자) — VARCHAR(255) — NOT NULL
- last_modified_at (수정일자) — VARCHAR(255) — NOT NULL