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