1팀 ERD
테이블 (14)
Authority (권한)
- id (authority_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- name — VARCHAR — NOT NULL
- id (role_id) — BIGINT — 외래 키 → Role.id — NOT NULL
Image (이미지)
- id (image_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_Id) — VARCHAR — NOT NULL
- path — VARCHAR — NOT NULL — URL
- user_id — VARCHAR — NOT NULL
- type — VARCHAR — NOT NULL
- created_at — VARCHAR — NOT NULL
- updated_at — VARCHAR — NOT NULL
- status — VARCHAR — NOT NULL
- originName (origin_name) — VARCHAR — NOT NULL
Role (역할)
- id (role_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- value — VARCHAR — NOT NULL
User_Role (매핑 테이블)
- id (user_role_id) — BIGINT — 기본 키 — NOT NULL
- id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- id (role_id) — BIGINT — 외래 키 → Role.id — NOT NULL
article (게시글)
- id (article_id) — BIGINT — 기본 키 — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- title — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
- thumbnail — VARCHAR — NOT NULL
- articleStatus (article_status) — VARCHAR — NOT NULL
chat (채팅)
- id (chat_id) — BIGINT — 기본 키 — NOT NULL
- id (chatroom_id) — 외래 키 → chatroom.id — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
chatroom (채팅방)
- id (chatroom_id) — 기본 키 — NOT NULL
- name (chatroom_name) — VARCHAR — NOT NULL
- createdBy (created_by) — BIGINT — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
chatroom - user (매핑테이블)
- id (member_id) — BIGINT — 기본 키 — NOT NULL
- nickname — VARCHAR — NOT NULL
- id (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- id (chatroom_id) — BIGINT — 외래 키 → chatroom.id — NOT NULL
image-map-table (Untitled2)
- id — BIGINT — 기본 키 — NOT NULL
- ImageId (image_id) — BIGINT — 외래 키 → Image.id — NOT NULL
- refApiId (ref_api_id) — VARCHAR — NOT NULL
- type — VARCHAR — NOT NULL — refApiId - 참조합 타입
order (주문)
- id (order_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- orderStatus (order_status) — VARCHAR — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR
- articleId (article_id) — BIGINT — 외래 키 → article.id — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
refresh token (리프레시 토큰)
- id (refreshToekn_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- refreshToken (refresh_token) — VARCHAR — NOT NULL
report (신고)
- id (report_id) — BIGINT — 기본 키 — NOT NULL
- reporterId (reporter_id) — BIGINT — 외래 키 → user.id — NOT NULL — 신고한 사람
- reportedId (reported_id) — BIGINT — 외래 키 → user.id — NOT NULL — 신고당한 사람
- apiId (api_id) — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
review (후기)
- id (review_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- content — VARCHAR — NOT NULL
- point — INTEGER — NOT NULL
- createdAt (create_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
- userId (user_id) — BIGINT — 외래 키 → user.id — NOT NULL
- articleId (article_id) — BIGINT — 외래 키 → article.id — NOT NULL
user (user_entity)
- id (user_id) — BIGINT — 기본 키 — NOT NULL
- apiId (api_id) — VARCHAR — NOT NULL
- username — VARCHAR — NOT NULL
- password — VARCHAR — NOT NULL
- email — VARCHAR — NOT NULL
- phone — VARCHAR — NOT NULL
- address — VARCHAR — NOT NULL
- createdAt (created_at) — DATETIME — NOT NULL
- updatedAt (updated_at) — DATETIME — NOT NULL
- status — VARCHAR — NOT NULL
- userProfilePic (user_profile_pic) — VARCHAR