Whisper In A Bottle

Tables (4)

Letter (letter)

  • letter_id (Key) — bigint — Primary key — NOT NULL
  • content (Field) — string

LetterState (letter_state)

  • letter_id (Key) — bigint — Foreign key → Letter.letter_id — NOT NULL
  • sender_id (Key3) — string — Foreign key → User.id — NOT NULL
  • receiver_id (Key4) — string — Foreign key → User.id — NOT NULL
  • send_time (Field3) — bigint

User (users)

  • id (Key) — bigint — Primary key — NOT NULL
  • password (Field) — bigint

UserState (user_state)

  • id (Key) — bigint — Foreign key → User.id — NOT NULL
  • receive_time (Field) — bigint
  • last_login_time (Field2) — bigint
  • last_login_ip (Field3) — string