SGEE

Tables (7)

area

  • area_id — INT — Primary key — NOT NULL
  • name — ENUM — NOT NULL

career

  • career_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL

certificate

  • certificate_id — INT — Primary key — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL

member

  • member_id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200) — NOT NULL
  • active — ENUM — NOT NULL
  • time — VARCHAR(20) — NOT NULL
  • profile — VARCHAR(255)

member_area

  • member_id — INT — Foreign key → member.member_id — NOT NULL
  • area_id — INT — Foreign key → area.area_id — NOT NULL

member_week

  • week_id — INT — Foreign key → week.week_id — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL

week

  • week_id — INT — Primary key — NOT NULL
  • name — ENUM — NOT NULL