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