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