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