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