test

Tables (8)

appnotification (Untitled2)

  • idAppNoti (Key) — int(11) — Primary key — NOT NULL
  • idUser — int — Foreign key → user.idUser — NOT NULL
  • message (Field) — text
  • notiType (Field2) — varchar(5) — # 사용자앱 D: 기기 알림 R: 예약 알림 E: 오류 알림 V: 이용권 알림 C: 쿠폰 알림 # 매니저앱 S: 서비스 알림 M: 유지보수 알림 RP: 리포트 알림 DM: 기기 관리 알림
  • read (Field3) — tinyint(1)
  • createDate (Field4) — datetime

code (Untitled4)

  • idCode (Key2) — int — Primary key — NOT NULL
  • idCodeGroup (Key) — int(11) — Foreign key → codegroup.idCodeGroup — NOT NULL
  • codeKey (Field) — varchar(50)
  • codeValue (Field5) — varchar(255)
  • language (Field3) — varchar(10)
  • isShow (Field2) — char(1)
  • extra1 (Field4) — varchar(255)
  • extra2 (Field6) — varchar(255)
  • extra3 (Field7) — varchar(255)
  • extra4 (Field8) — vharchar(255)
  • createDate (Field9) — datetime
  • modifyDate (Field10) — datetime

codegroup (Untitled3)

  • idCodeGroup (Key) — int(11) — Primary key — NOT NULL
  • groupName (Field) — varchar(100)
  • groupExplain (Field2) — varchar(200)
  • isShow (Field3) — char(1)
  • createDate (Field4) — datetime
  • modifyDate (Field5) — datetime

franchise (CopyOfUntitled)

  • idFranchise (idUser) — int — Primary key — NOT NULL
  • name (Field) — varchar(45)
  • franchiseId (Field2) — varchar(45)

guide (Untitled5)

  • idGuide (Key) — int(11) — Primary key — NOT NULL
  • title (Field) — varchar(200)
  • subtitle (Field2) — varchar(200)
  • chontent (Field3) — text
  • language (Field4) — varchar(10)
  • isType (Field7) — enum('L','D)
  • isGuide (Field6) — enum('E', 'U', 'R')
  • seq (Field5) — int(11)
  • createDate (Field8) — datetime
  • modifyDate (Field9) — datetime

imagesdata (Untitled6)

  • idDate (Key) — int(11) — Primary key — NOT NULL
  • fkid (Field) — varchar(100)
  • imgType (Field2) — enum(S, V) — S: store V: voucher
  • imgNmame (Field3) — varchar(255)
  • imgPath (Field7) — varchar(255)
  • imgUrl (Field4) — varchar(255)
  • txt (Field5) — text
  • createDate (Field6) — datetime
  • modifyDate (Field8) — datetime

orderitem (Untitled7)

  • idOrderitem (Key) — int(11) — Primary key — NOT NULL
  • Field

user (Untitled)

  • idUser — int — Primary key — NOT NULL
  • userNo (Field) — varchar(128)
  • businessType (Field2) — varchar(45)
  • createDate (Field3) — datetime
  • email (Field4) — varchar(128)
  • emailNotification (Field5) — varchar(8)
  • firstLogin (Field6) — boolean
  • isFranchiseOwner (Field7) — boolean
  • isLocked (Field8) — boolean
  • level (Field11) — varchar(45)
  • idFranchise (idUser2) — int — Foreign key → franchise.idFranchise — NOT NULL
  • idRole (Field12) — boolean
  • serviceCode (Field9) — varchar(45)
  • appNotification (Field13) — enum('Y','N')
  • appNotificationDetail (Field14) — json