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