test
Tables (5)
Client (CopyOf담당자)
- unique_id (Key) — Primary key — NOT NULL
- name (이름) — text
- phone_number (전화번호) — number
- email (이메일) — text
- requirement (요구사항) — Requirement
- estimation (자가견적) — Estimation
- develop_start_at (희망개발시작시간) — date
- develop_end_at (희망개발종료시간) — date
ClientRequirment (요구사항)
- uniquie_id (Key) — Primary key — NOT NULL
- Client (클라이언트) — Client — Foreign key → Client.unique_id — NOT NULL
- work_spectrum (업무범위) — WORK_SPECTRUM
- proparing_conditon (기획상태) — PREPARING_CONDITION
- category (카테고리) — REQUIRMENT_CATEGORY
- Field
Manager (담당자)
- unique_id (Key) — Primary key — NOT NULL
- name (이름) — text
- phone_number (전화번호) — number
- email (이메일) — text
- user (Key2) — Foreign key → User.unique_id — NOT NULL
User (유저)
- unique_id (Key) — Primary key — NOT NULL
- name (이름) — text
- email (이메일) — text
- phone_number (전화번호) — number
- user_state (유저상태) — USER_STATE(ACTIVE, UNACTIVE)
- uesr_approve_at (유저승인날짜) — date
- user_request_at (승인요청날짜) — date
- approve_user (승인자) — User
- user_type (유저타입) — USER_TYPE(ADMIN,DEVELOPER,MAKETER,CLIENT)
- init_password (초기비밀번호) — number
- controlo_password (활성비밀번호) — number
- sns_type (sns타입) — SNS_TYPE(GOOGLE,KAKAOTALK)
- is_corp (기업여부) — boolean
- corp_name (기업명) — text
- client_memo (고객메모) — text
- user_working (Field) — USER_WORKING(WORKING,RETIREMENT)
- credit (보유크레딧) — number
- bank (은행명) — BANK
- account_num (계좌번호) — text
- account_holder (예금주명) — text
- user_rank (고객등급) — USER_RANK(S,A,B,C)
- ------------ (---------------) — ------------------
- department_name (팀) — DEPARTMENT_NAME
- department_generattion (기수) — DEPARTMENT_ GENERATION
- department_role (직책) — DEPARTMENT_ROLE
- department_filed (분야) — DEPARTMENT_FILED
- profile_image (프로필이미지) — image
- color (고유색상) — color
- is_term (약관여부) — boolean
- joined_at (입사일) — date