Tenshii

Tables (21)

Account (사용자 계정 정보)

  • user_id (사용자 아이디) — Varchar — Primary key — NOT NULL
  • user_name (사용자명) — Varchar — NOT NULL
  • nickname (닉네임) — Varchar — NOT NULL
  • email (사용자 이메일) — Varchar — NOT NULL
  • passwd (사용자 비밀번호) — Varchar — NOT NULL
  • login_type (소셜계정) — Varchar
  • role (직업) — Varchar
  • skills (스킬) — Varchar[]
  • wallet_id (지갑주소) — Varchar

Club (클럽)

  • club_id (식별자) — uuid — Primary key — NOT NULL
  • club_type (클럽 종류) — Varchar — NOT NULL
  • email (대표 이메일) — Varchar — NOT NULL
  • club_name (클럽명) — Varchar — NOT NULL
  • club_image (클럽 이미지 url) — Varchar — NOT NULL
  • club_extra_image (기타 이미지 서브 url) — Varchar[]
  • club_url (official link) — Varchar
  • verified (Field) — Boolean — NOT NULL
  • Field2

Notification (알림 테이블)

  • notify_id (식별자) — uuid — Primary key — NOT NULL
  • template_code (템플릿 코드) — Bigint — NOT NULL
  • sender_id (보내는 사람) — Varchar
  • receiver_id (받는 사람) — Varchar — NOT NULL
  • contents (내용) — Jsonb — NOT NULL
  • create_at (생성일) — Datetime — NOT NULL
  • type (카테고리) — Varchar — NOT NULL
  • is_checked (Field) — Boolean — NOT NULL

Project (프로젝트)

  • project_id (식별자) — uuid — Primary key — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Account.user_id — NOT NULL
  • club_id (식별자2) — uuid[] — Foreign key → Club.club_id
  • project_name (프로젝트명) — varchar — NOT NULL
  • description (프로젝트설명) — varchar
  • category (카테고리) — varchar[] — NOT NULL
  • disclosure (공개 범위) — varchar — NOT NULL
  • project_image (프로젝트 이미지 url) — Project_Link

Project_Invitation (프로젝트 초대)

  • invitation_id (초대 식별자) — uuid — Primary key — NOT NULL
  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Project.user_id — NOT NULL
  • club_id (식별자2) — uuid — Foreign key → Project.club_id — NOT NULL
  • target_user_id (대상 아이디) — Varchar — NOT NULL
  • role (역할) — Varchar — NOT NULL
  • status (상태) — Varchar — NOT NULL
  • message (메시지) — Varchar

Project_Link (프로젝트 링크)

  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • url (링크) — Varchar — NOT NULL
  • type (타입) — Varchar — NOT NULL
  • name (이름) — Varchar — NOT NULL

Project_member (프로젝트 멤버 목록)

  • project_id (식별자) — uuid — Foreign key → project_result.project_id — NOT NULL
  • club_id (식별자2) — uuid — Foreign key → project_result.club_id — NOT NULL
  • user_id (사용자 계정명) — varchar — NOT NULL
  • create_at (생성일) — datetime — NOT NULL
  • delete_at (삭제일) — datetime

achievement_history (수여 내역)

  • achievement_id (식별자) — uuid — Primary key — NOT NULL
  • project_id (프로젝트 식별자) — uuid — Primary key — NOT NULL
  • status (상태) — varchar — NOT NULL
  • sender_id (수여한 사람) — Varchar — NOT NULL
  • receiver_id (수여받은 사람) — Varchar — NOT NULL
  • create_at (생성일) — Datetime — NOT NULL
  • update_at (수정일) — Datetime — NOT NULL

achievement_list (nft 리스트)

  • achievement_id (Key) — uuid — Primary key — NOT NULL
  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Project.user_id — NOT NULL
  • club_id (식별자2) — uuid — Foreign key → Project.club_id — NOT NULL
  • name (nft 이름) — Varchar — NOT NULL
  • description (설명) — Varchar
  • on_chain (Field) — Boolean — NOT NULL

club_invitation (Untitled3)

  • club_id (식별자) — uuid — Foreign key → Club.club_id — NOT NULL
  • invitation_id (초대 식별자) — uuid — NOT NULL
  • status (상태) — boolean — NOT NULL
  • create_at (Field) — Datetime — NOT NULL
  • update_at (수정일) — Datetime

club_member (클럽 멤버)

  • user_id (사용자 아이디) — Varchar — Foreign key → Account.user_id — NOT NULL
  • club_id (식별자) — uuid — Foreign key → Club.club_id — NOT NULL
  • user_type (유저 타입) — Varchar — NOT NULL

club_nft (클럽 발행 nft)

  • club_id (식별자) — uuid — Foreign key → Club.club_id — NOT NULL
  • nft_type (nft 유형) — Varchar — NOT NULL
  • nft_property (nft 속성) — Varchar — NOT NULL
  • certificate_name (증명서 이름) — Varchar — NOT NULL
  • description (증명서 설명) — Varchar
  • avatar_type (아바타 타입) — Varchar
  • avatar_url (아바타 이미지 url) — Varchar[]
  • certificate_url (증명서 url) — Varchar
  • contract_url (컨트랙트 주소) — Varchar

club_permission (Untitled2)

  • club_id (식별자) — uuid — Foreign key → Club.club_id — NOT NULL
  • target_user_id (Field) — Varchar — NOT NULL
  • granted_user_id (Field2) — Varchar — NOT NULL
  • is_can_invite (Field3) — Boolean — NOT NULL
  • is_make_mission (Field4) — Boolean — NOT NULL
  • is_make_certificate (Field5) — Boolean — NOT NULL
  • is_can_verify (Field6) — Boolean — NOT NULL
  • is_can_evaluate (Field7) — Boolean — NOT NULL
  • create_at (Field8) — Datetime — NOT NULL
  • update_at (Field9) — Datetime

evaluation_list (평가항목)

  • eval_id (평가항목 식별자) — uuid — Primary key — NOT NULL
  • contents (질문) — Varchar — NOT NULL
  • category (카테고리) — Varchar — NOT NULL
  • weight (가중치) — Float — NOT NULL
  • max_score (최대치) — BigInt — NOT NULL
  • Scale (조정치) — BigInt — NOT NULL

profile_feedback (평판 열람내역)

  • user_id (사용자 아이디) — Varchar — Foreign key → Account.user_id — NOT NULL
  • client_id (요청한 사람) — Varchar — NOT NULL
  • status (상태) — Varchar — NOT NULL
  • create_at (요청 생성일) — Datetime — NOT NULL
  • expired_at (만료일) — Datetime — NOT NULL

project_category (프로젝트 카테고리)

  • category_name (카테고리명(키)) — Varchar — Primary key — NOT NULL
  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • club_id (식별자2) — uuid[] — Foreign key → Project.club_id
  • category_detail (상세) — Varchar — NOT NULL

project_evaluation (Untitled)

  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Project.user_id — NOT NULL
  • club_id (식별자2) — uuid — Foreign key → Project.club_id — NOT NULL
  • contents (평가내용) — evaluation_list — NOT NULL
  • create_at (생성일) — Datetime — NOT NULL
  • update_at (수정일) — Datetime — NOT NULL

project_mission (미션 목록)

  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • club_id (식별자2) — uuid[] — Foreign key → Project.club_id
  • mission_id (미션 식별자) — uuid — NOT NULL
  • contents (내용) — varchar
  • mssion_name (미션이름) — varchar — NOT NULL
  • create_at (생성일) — datetime — NOT NULL

project_result (내 성과 등록하기)

  • project_id (식별자) — uuid — Foreign key → Project.project_id — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Project.user_id — NOT NULL
  • club_id (식별자2) — uuid — Foreign key → Project.club_id — NOT NULL
  • contents (상세업무) — Varchar — NOT NULL
  • contents_detail (작업물 url) — Varchar
  • role (역할) — varchar — NOT NULL

project_tag (프로젝트 태그)

  • tag_id (식별자) — uuid — Primary key — NOT NULL
  • role (역할) — Varchar — NOT NULL
  • tag_name (태그명) — Varchar — NOT NULL

wallet_info (지갑 상세정보)

  • wallet_id (지갑주소) — Primary key — NOT NULL
  • user_id (사용자 아이디) — Varchar — Foreign key → Account.user_id — NOT NULL
  • certificate_career (내가 보유한 커리어 (수상) 증명서 디스플레이) — Varchar[]
  • certificate_educate (내가 보유한 커리어 (교육) 증명서 디스플레이) — Varchar[]
  • wallet_type (지갑 타입(위핀, 등)) — Varchar — NOT NULL
  • profile_avatar (프로필 아파타) — Varchar