notej
테이블 (3)
회원 (user_table)
- 회원ID (user_id) — bigint — 기본 키
- 회원상세ID (user_desc_id) — bigint — 외래 키 → 회원상세.회원상세ID — NOT NULL
- 유저네임 (username) — varchar
- 패스워드 (password) — varchar
- 이메일 (email) — varchar
- 계정락날짜 (account_expired) — datetime
- 실패카운트 (failed_count) — int
- 계정락 (account_locked) — tinyint
- 생성 날짜 (create_dt) — datetime
- 수정 날짜 (last_modified_dt) — datetime
- 생성자 (create_by) — varchar
- 수정자 (last_modified_by) — varchar
- Field (user_role) — enum
회원상세 (user_desc)
- 회원상세ID (user_desc_id) — bigint — 기본 키 — NOT NULL
- Field (social_email) — varchar
- Field (social_facebook) — varchar
- Field (social_git_hub) — varchar
- Field (social_other) — varchar
- Field (social_twitter) — varchar
- Field (theme) — enum
- Field (blog_title) — varchar
- Field (profile_pic) — varchar
- Field (description) — varchar
- Field (comment_alarm) — bit
- Field (notejalarm) — bit
- Field (create_dt) — datetime
- Field (last_modified_dt) — datetime