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)