voiceStore

테이블 (10)

권한 (permit)

  • permitSeq (permit_seq) — bigint — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255)
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)

권한메뉴 (permit_menu)

  • permitMenuSeq (permit_menu_seq) — bigint — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255)
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)

글 (post)

  • postSeq (post_seq) — bigint — 기본 키 — NOT NULL
  • tagSeq (tag_seq) — bigint — 외래 키 → 태그.tagSeq — NOT NULL
  • likeSeq (like_seq) — bigint — 외래 키 → 좋아요.likeSeq — NOT NULL
  • postName (post_name) — varchar(255)
  • postContent (post_content) — varchar(255)
  • insertTime (insert_time) — timestamp
  • updateTime (update_time) — timestamp
  • insertUserSeq (insert_user_seq) — bigint
  • updateUserSeq (update_user_seq) — bigint
  • type — varchar(255)
  • startTime (start_time) — varchar(255)
  • videoTitle (video_title) — varchar(255)
  • totalTime (total_time) — varchar(255)

상태 (user_status)

  • codeId (code_id) — varchar(255) — 기본 키 — NOT NULL
  • codeName (code_name) — varchar(255)
  • codeValue (code_value) — varchar(255)

유저 (t_user)

  • userSeq (user_seq) — bigint — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255) — 외래 키 → 상태.codeId — NOT NULL
  • userId (id) — varchar(255)
  • password — varchar(255)
  • userName (user_name) — varchar(255)
  • email — varchar(255)
  • tel — varchar(255)
  • status — varchar(255)
  • lastLoginDt (last_login_dt) — timestamp
  • insertUserSeq (insert_user_seq) — bigint
  • insertDt (insert_dt) — timestamp
  • updateUserSeq (update_user_seq) — bigint
  • updateDt (update_dt) — timestamp
  • provider — varchar(255)
  • providerId (provider_id) — varchar(255)

유저그룹 (user_group)

  • userGroupSeq (user_group_seq) — bigint — 기본 키 — NOT NULL
  • codeId (code_id) — varchar(255) — 외래 키 → 상태.codeId — NOT NULL
  • groupName (group_name) — varchar(255)
  • groupDesc (group_desc) — varchar(255)
  • insertUserSeq (insert_user_seq) — bigint
  • insertDt (insert_dt) — timestamp
  • updateUserSeq (update_user_seq) — bigint
  • updateDt (update_dt) — timestamp

유저그룹권한 (group_permit)

  • userGroupPermitSeq (user_group_permit_seq) — bigint — 기본 키 — NOT NULL
  • userGroupSeq (user_group_seq) — bigint — 외래 키 → 유저그룹.userGroupSeq — NOT NULL
  • permitSeq (permit_seq2) — bigint — 외래 키 → 권한.permitSeq — NOT NULL
  • permitMenuSeq (permit_menu_seq) — bigint — 외래 키 → 권한메뉴.permitMenuSeq — NOT NULL
  • insertUserSeq (insert_user_seq) — bigint
  • insertDt (insert_dt) — timestamp
  • updateUserSeq (update_user_seq) — bigint
  • updateDt (update_dt) — timestamp

유저그룹중간테이블 (user_in_group)

  • userInGroupSeq (user_in_group_seq) — bigint — 기본 키 — NOT NULL
  • userSeq (user_seq) — bigint — 외래 키 → 유저.userSeq — NOT NULL
  • userGroupSeq (user_group_seq) — bigint — 외래 키 → 유저그룹.userGroupSeq — NOT NULL
  • insertUserSeq (insert_user_seq) — bigint

좋아요 (t_like)

  • likeSeq (like_seq) — bigint — 기본 키 — NOT NULL
  • userSeq (user_seq) — bigint

태그 (tag)

  • tagSeq (tag_seq) — bigint — 기본 키 — NOT NULL
  • tagName (tag_name) — varchar(50)