MSS-RESEARCH_ERD_V1

Tables (7)

ADMIN_INFO (관리자정보)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • delarcount (Field) — INTEGER
  • appcount (Field2) — INTEGER
  • ttlnmcmplt (Field3) — INTEGER
  • untrtwater (Field4) — INTEGER
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

NOTICE (공지사항)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userId (외래키) — INTEGER — Foreign key → USER.id — NOT NULL
  • title (Field) — TEXT
  • order (Field2) — INTEGER
  • ison (Field3) — BOOLEAN
  • content (Field4) — TEXT
  • createdAt (Field5) — DATE
  • updatedAt (Field6) — DATE

USER (회원(딜러/관리자))

  • id (Key) — INTEGER — Primary key — NOT NULL
  • join (Field) — STRING
  • email (Field2) — STRING
  • password (Field3) — STRING
  • salt (Field4) — STRING
  • birth (Field11) — DATE
  • tel (Field5) — STRING
  • master (Field7) — INTEGER
  • access (Field8) — BOOLEAN
  • typememo (Field17) — TEXT
  • logincount (Field9) — INTEGER
  • ttlpoint (Field12) — INTEGER
  • allorder (Field6) — INTEGER
  • noneorder (Field13) — INTGER
  • ttlpypnts (Field14) — INT
  • createdAt (Field15) — DATE
  • updatedAt (Field16) — DATE

USER_APP (접수정보)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • type (Field15) — TEXT
  • name (Field) — STRING
  • birth (Field2) — DATE
  • tel (Field3) — STRING
  • zip (Field4) — JSON
  • gender (Field5) — STRING
  • payInsure (Field6) — INTEGER
  • rsrvtdate (Field7) — DATE
  • talktime (Field9) — DATE
  • requests (Field8) — TEXT
  • type (Field13) — STRING
  • memo (Field14) — TEXT
  • prscnInfrm (Field10) — TEXT
  • createdAt (Field11) — DATE
  • updatedAt (Field12) — DATE

USER_PERF (수행목록)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userId (외래키1) — INTEGER — Foreign key → USER.id — NOT NULL
  • cmtId (외래키) — INTEGER — Foreign key → USER_APP.id — NOT NULL
  • cash (Field) — INTEGER
  • cashcmpt (Field2) — INTEGER
  • type (Field5) — INTEGER
  • typememo (Field6) — TEXT
  • createdAt (Field3) — DATE
  • updatedAt (Field4) — DATE

USER_REFUNDS (환급내역)

  • id (Key) — Primary key — NOT NULL
  • userId (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • masterId (Key3) — INTEGER — Foreign key → USER.id — NOT NULL
  • point (Field) — INTEGER
  • type (Field4) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE

USER_SITE (딜러및 회원 사이트)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • userId (Key2) — INTEGER — Foreign key → USER.id — NOT NULL
  • visit (Field) — INTEGER
  • seotitle (Field4) — TEXT
  • metadata (Field5) — TEXT
  • seodescription (Field7) — TEXT
  • seokeyword (Field6) — TEXT
  • author (Field8) — TEXT
  • publisher (Field9) — TEXT
  • createdAt (Field2) — DATE
  • updatedAt (Field3) — DATE