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