pratice4
Tables (13)
alarm
- alarm_id — INT
- enabled — TINYINT(1) — NOT NULL
- u_id — INT — NOT NULL
album
- album_id — INT
- album_title — VARCHAR(100)
- gup_id — INT — NOT NULL
- picture — VARCHAR(500)
- u_id — INT — NOT NULL
- submitted_at — DATETIME — NOT NULL
calendar
- cal_id — INT
- gup_id — INT — NOT NULL
- cal_title — VARCHAR(50) — NOT NULL
diary
- di_id — INT
- di_title — VARCHAR(100)
- di_content — MEDIUMTEXT
- feedbook — MEDIUMTEXT
- emotion — VARCHAR(100)
- u_id — INT — NOT NULL
- diary_at — DATETIME — NOT NULL
group_answer
- answer_id — INT
- gq_id — INT — NOT NULL
- gup_title — VARCHAR(100)
- user_answer — TEXT
- u_id — INT — NOT NULL
- flag — TINYINT(1) — NOT NULL
- submitted_at — DATETIME — NOT NULL
group_question
- gq_id — INT
- gup_id — INT — NOT NULL
- qi_id — INT — NOT NULL
- day — DATE — NOT NULL
- slot — TINYINT — NOT NULL
groups
- gup_id — INT
- groupname — VARCHAR(100) — NOT NULL
- code — VARCHAR(24)
- image — VARCHAR(500)
groups_schedule
- gu_sc_id — INT
- u_id — INT — NOT NULL
- sch_id — INT — NOT NULL
groups_user
- u_id — INT — Primary key — NOT NULL
- gup_id — INT — Primary key — NOT NULL
- role — VARCHAR(20) — NOT NULL
- score — TINYINT
- leader — TINYINT(1) — NOT NULL
question_inventory
- qi_id — INT
- qi_content — TEXT — NOT NULL
- qi_number — INT — NOT NULL
sch_comment
- com_id — INT
- sch_body — VARCHAR(500)
- date_at — DATE
- sch_id — INT — NOT NULL
schedule
- sch_id — INT
- sch_title — VARCHAR(100)
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
- sch_content — TEXT
- permission — TINYINT(1)
- u_id — INT — NOT NULL
- cal_id — INT — NOT NULL
users
- u_id — INT
- social — VARCHAR(10) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- username — VARCHAR(50) — NOT NULL
- age — TINYINT
- gender — VARCHAR(5)
- image — VARCHAR(500)