EduErd
Tables (16)
Center (센터)
- id (Key) — Primary key — NOT NULL
- basecenter (Field)
- centername (Field2)
- type (Field3)
- tel (Field4)
- phone (Field5)
- email (Field6)
- homepage (Field7)
- start (Field8)
- end (Field9)
- zip (Field10)
- name (Field11)
- bsnumber (Field12)
- contract (Field13)
attendence (출석)
- id (Key) — Primary key — NOT NULL
- userid (Key2) — Foreign key → user.id — NOT NULL
- seat (Field)
- start (Field2)
- end (Field3)
- mean (Field4)
- memo (Field5)
- validate (Field6)
board (보드)
- id (Key) — Primary key — NOT NULL
- boardcategoryid (Key2) — Foreign key → boardcategory.id — NOT NULL
- title (Field)
- contents (Field2)
- type (Field3)
- isPopUp (Field4)
- count (Field5)
boardcategory (게시판 관리 리스트)
- id (Key) — Primary key — NOT NULL
- centerid (Key2) — Foreign key → Center.id — NOT NULL
- order (Field)
- title (Field2)
- ison (Field3)
chat (채팅룸)
- id (Key) — Primary key — NOT NULL
- targetid (Key2) — Foreign key → user.id — NOT NULL
- myid (Key3) — Foreign key → user.id — NOT NULL
- lastmessage (Field)
gmprofile (관리자프로필)
- id (Key2) — Primary key — NOT NULL
- userid (Key) — Foreign key → user.id — NOT NULL
- type (Field)
- task (Field2)
- position (Field3)
- day (Field4)
- info (Field5)
group (그룹)
- id (Key3) — Primary key — NOT NULL
- masterid (Key2) — 주관리자 — Foreign key → user.id — NOT NULL
- centerid (Key) — Foreign key → Center.id — NOT NULL
- name (Field)
- subject (Field2)
- subid (Key4) — 부관리자 — Foreign key → user.id — NOT NULL
- memo (Field3)
messages (메세지리스트)
- roomid (Key) — Foreign key → chat.id — NOT NULL
- message (Field)
- images (Field2)
payment (결제내역)
- id (Key) — Primary key — NOT NULL
- useird (Key22) — Foreign key → user.centerid — NOT NULL
planner (시험)
- id (Key) — Primary key — NOT NULL
- centerid (Key2) — Foreign key → Center.id — NOT NULL
- title (시험명)
- type (Field)
- endday (Field2)
- endtime (Field3)
- time (Field4)
- ison (Field5)
- examtype (Field6)
- page (Field7)
profile (프로필)
- id (Key) — Primary key — NOT NULL
- userid — Foreign key → user.id — NOT NULL
- schoolname (Field)
- class (Field2)
- grade (Field3)
room (룸)
- id (Key2) — Primary key — NOT NULL
- centerid (Key) — Foreign key → Center.id — NOT NULL
- name (Field)
- ison (Field2)
- isvalidate (Field3)
seat (좌석)
- id (Key) — Primary key — NOT NULL
- userid (Key2) — Foreign key → user.id — NOT NULL
- roomid (Key22) — Foreign key → room.id — NOT NULL
- number (Field)
- start (Field2)
- end (Field3)
- type (Field4)
- ison (Field5)
- attendance (Field6)
smslog (메세지 발송내역)
- id (Key) — Primary key — NOT NULL
- naem (Field)
- tel (Field2)
- type (Field3)
- title (Field4)
- from (Field5)
- msgtype (Field6)
- contents (Field7)
user (유저테이블)
- id (Key) — Primary key — NOT NULL
- centerid (Key2) — Foreign key → Center.id — NOT NULL
- email (Field)
- myid (Field2)
- password (Field4)
- nickname (Field5)
- in (Field6)
- out (Field3)
- salt (Field7)
- avatar (Field8)
- gm (Field9)
- zip (Field10)
- tel (Field11)
- phone (Field12)
- name (Field13)
- access (Field14)
- fcm (Field15)
- did (Field16)
- cash (Field17)
- isvalidate (Field18)
- accessDate (Field19)
userplanner (학습계획/수행평가)
- id (Key) — Primary key — NOT NULL
- userid (Key2) — Foreign key → user.id — NOT NULL
- type (Field)
- subject (Field2)
- contents (Field3)
- ison (Field4)
- page (Field5)