notej

테이블 (3)

댓글 (comment)

  • Key — 기본 키 — NOT NULL

회원 (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