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