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