night
Tables (4)
Buddy (유저버디관계)
- user_id_1 (유저아이디1) — INT — Primary key — NOT NULL
- user_id_2 (유저아이디2) — INT — Primary key — NOT NULL
Emotion (편지감정)
- id (레터아이디) — INT — Foreign key → Letter.id — NOT NULL
- user_id (유저아이디) — int — Foreign key → Letter.user_id — NOT NULL
- type (감정타입) — INT
- level (감정수준) — INT
Letter (편지)
- id (아이디) — INT — Primary key — NOT NULL
- user_id (유저아이디) — int — Foreign key → User.id — NOT NULL
- contents (편지내용) — TEXT
- sended_at (발송시간) — DATE
- opened_at (열람시간) — DATE
User (유저)
- id (아이디) — int — Primary key — NOT NULL
- nickname (닉네임) — STRING
- password (비밀번호) — STRING