calendar

Tables (3)

Untitled (user_plan_map)

  • key (member_id) — bigint — Primary key
  • Key2 (plan_id) — bigint — Primary key — NOT NULL
  • Key3 (calendar_id) — bigint — Primary key — NOT NULL
  • Key (team_id) — bigint — Foreign key → Untitled.Key
  • Field (attend) — tinyint — NOT NULL
  • Field (deleted) — tinyint(1) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

Untitled (team)

  • Key (id) — bigint — Primary key
  • Field (name) — varchar(30) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

user

  • Key (account_id) — varchar(50) — Primary key — NOT NULL
  • Field (iso_code) — varchar(2)
  • Field (lunar) — tinyint — NOT NULL
  • Field (alarm_code) — tinyint
  • Field (view_type) — tinyint(1) — NOT NULL
  • Field (time_offset) — int — NOT NULL
  • Field (created_at) — datetime
  • Field (updated_at) — datetime — NOT NULL