skeleton--code

Tables (5)

conference

  • id — INT — Primary key — NOT NULL
  • owner_id — INT — Foreign key → user.id — NOT NULL
  • conference_category — INT — Foreign key → conference_category.id — NOT NULL
  • call_start_time — TIMESTAMP — NOT NULL
  • call_end_time — TIMESTAMP — NOT NULL
  • thumbnail_url — VARCHAR(100) — NOT NULL
  • title — VARCHAR(20) — NOT NULL
  • description — VARCHAR(100) — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

conference_category

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(10) — NOT NULL

conference_history

  • id — INT — Primary key — NOT NULL
  • conference_id — INT — Foreign key → conference.id — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • action — SMALLINT — NOT NULL
  • inserted_time — TIMESTAMP — NOT NULL

user

  • id — INT — Primary key — NOT NULL
  • department — VARCHAR(20) — NOT NULL
  • name — VARCHAR(10) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • position — VARCHAR(10) — NOT NULL
  • user_id — VARCHAR(16) — NOT NULL

user_conference

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → user.id — NOT NULL
  • conference_id — INT — Foreign key → conference.id — NOT NULL