capsule

Tables (4)

Capsule (캡슐)

  • capsuleID (캡슐ID) — bigint — Primary key — NOT NULL
  • senderID (전송자 ID) — bigint — Foreign key → User.memberID — NOT NULL
  • send_at (전송 날짜) — date
  • arrive_at (도착 날짜) — date
  • music (음악링크) — text
  • theme (캡슐 테마) — varchar(50)
  • sendState (전송 상태) — boolean

Contents (캡슐 내용)

  • contentsID (내용ID) — bigint — Primary key — NOT NULL
  • capsuleID (캡슐ID) — bigint — Foreign key → Capsule.capsuleID — NOT NULL
  • imageUrl (이미지 URL) — varchar(255)
  • text (캡슐 내용) — text

Receiver (캡슐 수신자)

  • recipientID (수신ID) — bigint — Primary key — NOT NULL
  • capsuleID (캡슐ID) — bigint — Foreign key → Capsule.capsuleID — NOT NULL
  • toEmail (수신자 email) — varchar(50)
  • readState (읾음 상태) — boolean

User (사용자)

  • memberID (사용자 ID) — bigint — Primary key — NOT NULL
  • email (사용자 email) — varchar(50)
  • birth (생년월일) — date
  • created_at (가입날짜) — date