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