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