TingTingAccount

Tables (4)

Code (Untitled2)

  • code (Field) — 기독교
  • codeGroup (Field2) — 종교
  • Field3

CodeGroup (Untitled4)

  • codeGroup (Field) — 종교
  • codeGroupName (Field2)
  • codeGroupDescrition (Field3)

User (Untitled)

  • userEmail (Key) — VARCHAR(64) — Primary key — NOT NULL — 홍길동@naver/cp,
  • userNo (Field) — BIGINT — NOT NULL
  • password (Field2) — VARCHAR(64) — NOT NULL
  • salt (Field3) — VARCHAR(32) — NOT NULL
  • registerDate (Field4) — DATETIME — NOT NULL
  • lastLoginSuccessDate (Field6) — DATETIME — NOT NULL
  • updateDate (Field5) — DATETIME — NOT NULL
  • isDel (Field8) — CHAR(1) — NOT NULL
  • university (Field7) — VARCHAR(32)
  • major (Field9) — VARCHAR(32)
  • userName (Field10) — VARCHAR(32)
  • Field11

UserDetail (Untitled3)

  • userEmail (Key) — VARCHAR(64) — Foreign key → User.userEmail — NOT NULL
  • topic (Field2)
  • value (Field3)