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