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