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