boostcamp

Tables (5)

action_histories (Untitled5)

  • action_history_id (Key) — BIGINT — Primary key — NOT NULL
  • action_id (Key2) — INT — Foreign key → actions.action_id — NOT NULL
  • user_id (Key3) — BIGINT — Foreign key → users.user_id — NOT NULL
  • time (Field) — DATETIME

actions (Untitled2)

  • action_id (Key) — INT — Primary key — NOT NULL
  • page_id (Key2) — SMALLINT — Foreign key → pages.page_id — NOT NULL

page_transitions (Untitled4)

  • transition_id (Key) — BIGINT — Primary key — NOT NULL
  • from_id (Key2) — SMALLINT — Foreign key → pages.page_id — NOT NULL
  • to_id (Key3) — SMALLINT — Foreign key → pages.page_id — NOT NULL
  • user_id (Key4) — BIGINT — Foreign key → users.user_id — NOT NULL
  • time (Field) — DATETIME

pages (Untitled)

  • page_id (Key) — SMALLINT — Primary key — NOT NULL
  • Field

users (Untitled3)

  • user_id (Key) — BIGINT — Primary key — NOT NULL