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)