PJT_SUB1
Tables (5)
conference (컨퍼런스)
- id — Integer — Primary key — NOT NULL
- owner_id — Integer
- conference_category — Integer
- call_start_time — DateTime
- call_end_time — DateTime
- thumbnail_url — String
- title — String
- description — VARCHAR
- is_active — Boolean
conference_category (컨퍼런스 종류)
- id — Integer — Primary key — NOT NULL
- name — String
conference_history (컨퍼런스 이해)
- id — Integer — Primary key — NOT NULL
- conference_id — Integer
- user_id — Integer
- action — SmallInteger (CREATE,JOIN,EXIT)
- inserted_time — DateTime
user (사용자)
- id — Integer — Primary key — NOT NULL
- department — String
- position — String
- name — String
- user_id — String
- password — String
user_conference (현재 동작 중인 방 정보)
- id — Integer(PK) — Primary key — NOT NULL
- conference_id — Integer
- user_id — Integer