JoinU
Tables (3)
Event
- id — INT — Primary key
- title — VARCHAR(100) — NOT NULL
- start — DATE
- end — DATE
- disabled — BOOLEAN
- color — VARCHAR(30)
- editable — BOOLEAN
- deletable — BOOLEAN
- allDay — BOOLEAN
Member
- id — INT — Primary key
- loginId — VARCHAR(30) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(30) — NOT NULL
- birthDate — DATE — NOT NULL
- gender — ENUM('MALE', 'FEMALE') — NOT NULL
- email — VARCHAR(30) — NOT NULL
User_Event
- user_id — INT — Foreign key → Member.id
- event_id — INT — Foreign key → Event.id