Neverver

Tables (6)

Entity (Member)

  • id (member_uuid) — PRIMARY KEY — Primary key — NOT NULL
  • Field2 (member_id) — NOTNULL
  • Field3 (member_name) — NOTNULL
  • Field4 (member_pw) — NOTNULL
  • Field (member_grade) — DEFAULT USER
  • Field7 (nickname) — NOTNULL
  • Field5 (phonenumber) — NOTNULL
  • Field6 (email) — NOTNULL

Entity (Notice)

  • Key (notice_id) — PRIMARY KEY — Primary key — NOT NULL
  • id (member_uuid) — FORIGN KEY — Foreign key → Entity.id — NOT NULL
  • Field (category) — NOTNULL
  • Field (ntitle) — NOTNULL
  • Field (ncontent) — notnull
  • Field (createdate) — notnull

Entity (Photo)

  • photo_id — PRIMARY KEY — Primary key — NOT NULL
  • Key (notice_id2) — FORIGN KEY — Foreign key → Entity.Key — NOT NULL
  • Field (photo_uuid) — NOT NULL
  • Field2 (photo_originname) — NOTNULL

Entity (Schedule)

  • Key (schedule_id) — PRIMARY KEY — Primary key — NOT NULL
  • Key (idle_id) — PRIMARY KEY — Foreign key → Entity.Key — NOT NULL
  • id (member_uuid) — FORIGN KEY — Foreign key → Entity.id — NOT NULL
  • Field (date) — NOT NULL

Entity (BaseEntity)

  • createdat — notnull
  • Field2 (updateat) — notnull
  • Field3 (deleteat) — notnull
  • Field4 (createmember) — NOTNULL
  • Field (updatemember) — default notyet
  • Field (deleteMember) — default notyet

Entity (Idle)

  • Key (idle_id) — PRIMARY KEY — Primary key — NOT NULL
  • Field (idle_name) — NOT NULL
  • Field (idle_birthday) — NOT NULL