PET

Tables (5)

Chat (Untitled4)

  • m_id (메시지아이디) — int — Primary key — NOT NULL
  • u_id (유저아이디) — str — Foreign key → User.u_id — NOT NULL
  • content (내용) — str
  • timestamp (시간) — time

Image (Untitled5)

  • i_id (이미지아이디) — Primary key — NOT NULL
  • u_id (유저아이디) — str — Foreign key → User.u_id — NOT NULL
  • file (이미지) — file

Pet (Untitled2)

  • u_id (유저아이디) — str — Foreign key → User.u_id — NOT NULL
  • name (이름) — str
  • Image (이미지) — Image
  • hygiene (위생) — int
  • hunger (배고픔) — int
  • happiness (행복) — int
  • personality (성격) — int
  • growth (성장도) — int

User (Untitled)

  • u_id (유저아이디) — str — Primary key — NOT NULL

Wallet (Untitled3)

  • u_id (유저아이디) — str — Foreign key → User.u_id — NOT NULL