s

Tables (8)

conference_history

  • chid — INT — Primary key — NOT NULL
  • act_type — INT — NOT NULL
  • history_create_time — DATETIME(6) — NOT NULL
  • cid — INT — Foreign key → conferences.cid
  • uid — INT — Foreign key → users.uid
  • INDEX — `FKr6l5nbnwdsn6b6cw9w6xot163`
  • INDEX — `FKpbec1fehjnrajw1vfsejicmlk`

conferences

  • cid — INT — Primary key — NOT NULL
  • activation — TINYINT(1) — NOT NULL
  • conf_end_time — DATETIME(6)
  • conf_start_time — DATETIME(6) — NOT NULL
  • uid — INT — NOT NULL

drawing_img_path

  • dipid — INT — Primary key — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • cid — INT — Foreign key → conferences.cid
  • pid — INT — Foreign key → projects.pid
  • uid — INT — Foreign key → users.uid
  • INDEX — `FKf5wcps99oynynwovr6wpn1s1e`
  • INDEX — `FK5rgbq0uxx1mr4pwcv4d4oqsj`
  • INDEX — `FK43sfc4th8ydujbxmgvcg3cjj6`

projects

  • pid — INT — Primary key — NOT NULL
  • activation — TINYINT(1) — NOT NULL
  • owner_id — INT — NOT NULL
  • pjt_desc — VARCHAR(255)
  • pjt_end_date — DATETIME(6)
  • pjt_name — VARCHAR(255) — NOT NULL
  • pjt_start_date — DATETIME(6) — NOT NULL
  • total_meet_time — DATETIME(6) — NOT NULL

prorile_image_path

  • pipid — INT — Primary key — NOT NULL
  • path — VARCHAR(255) — NOT NULL
  • uid — INT — Foreign key → users.uid
  • INDEX — `FKlq79ipd9vpt8kvksan67j342d`

user_conference

  • ucid — INT — Primary key — NOT NULL
  • cid — INT — Foreign key → conferences.cid
  • uid — INT — Foreign key → users.uid
  • INDEX — `FKirhov35puf31wdgu69vdftiy5`
  • INDEX — `FKdj6ainejbu74gwg3uwfq8aqi`

user_project

  • upid — INT — Primary key — NOT NULL
  • pid — INT — Foreign key → projects.pid
  • uid — INT — Foreign key → users.uid
  • INDEX — `FKioqr061pe71ku51a6yp6nr86y`
  • INDEX — `FKjk7r07ad2xew9s56vi6kvgxh5`

users

  • uid — INT — Primary key — NOT NULL
  • email — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(15) — NOT NULL
  • password — VARCHAR(100) — NOT NULL
  • reg_date — DATETIME(6) — NOT NULL