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

Untitled2

    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