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