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)