agricola

Tables (7)

Game Info (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • creator_id (Field2)
  • mode (Field3)
  • password (Field4)

Game Paricipant (Untitled4)

  • id (Key) — Foreign key → Game Info.id — NOT NULL
  • Field

Item (Untitled7)

  • item_id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → ItemUsageLog.id — NOT NULL
  • id (Key22) — Foreign key → ItemUsageLog.id — NOT NULL
  • name (Field)
  • type (Field2)
  • ability (Field3)
  • score (Field4)
  • limit (Field5)

ItemUsageLog (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • id (Key2) — Foreign key → Round Log.id — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL
  • used_at (Field)

Round Log (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • number (Field)
  • user_id (Field2)
  • action (Field3)
  • result (행동 결과)
  • item (얻은 아이템)
  • timestamp (Field6)

RoundAction (Untitled5)

  • action_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • action_type (Field2)
  • action_result (Field3)

User (Untitled)

  • user_id (Key) — Primary key — NOT NULL