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