backoffice
Tables (4)
Member (Untitled4)
- member_id (PK) — UUID — Primary key — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — TIMESTAMPTZ
- Field3
Notice (Untitled3)
- notice_id (PK) — UUID — Primary key — NOT NULL
- member_id (PK2) — UUID — Foreign key → Member.member_id — NOT NULL
- title (Field) — Varchar(200)
- date (Field2) — DATE
- created_at (Field3) — TIMESTAMPTZ
- updated_at (Field4) — TIMESTAMPTZ
Schedule (Untitled)
- schedule_id (PK) — UUID — Primary key — NOT NULL
- title (Field) — VARCHAR(200)
- schedule_date (Field2) — DATE
- schedule_time (Field3) — TIME
- sharing_status (Field4) — ENUM
- priority (Field5) — ENUM
- status (Field7) — ENUM
- created_at (Field8) — TIMESTAMPTZ
- updated_at (Field9) — TIMESTAMPTZ
schedule_member (Untitled2)
- schedule_id (PK) — UUID — Foreign key → Schedule.schedule_id — NOT NULL
- member_id (PK2) — UUID — Foreign key → Member.member_id — NOT NULL
- is_checked (Field) — ENUM
- cheked_at (Field2) — TIMESTAMPTZ