NDS-3

Tables (3)

Character (캐릭터 스티커)

  • id (PK) — int — Primary key — NOT NULL
  • s3_url (Field) — Varchar

Letter (편지)

  • id (PK) — int — Primary key — NOT NULL
  • Owner_id (FK) — Int — Foreign key → Owner.id — NOT NULL
  • Character_id (FK2) — int — Foreign key → Character.id — NOT NULL
  • content (Field) — Varchar
  • password (Field2) — Varchar
  • created_at (Field3) — date
  • modified_at (Field4) — Date

Owner (롤링페이퍼 주인)

  • id (PK) — Int — Primary key — NOT NULL
  • email (Field) — Varchar
  • username (Field2) — Varchar
  • personal_url (Field3) — Varchar
  • cognito_id (Field4) — Varchar