포트폴리오 사이트

테이블 (7)

ACTOR_PROFILES (Untitled4)

  • ACTOR_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (Field)
  • location (Field2)

AGENCY (Untitled7)

  • AGENCY_ID (Key) — 기본 키 — NOT NULL
  • USER_ID (Field)
  • job (직업)
  • company (소속(회사))
  • genre (직무)
  • Field3

BaseTable (Untitled2)

  • createdAt (생성일시)
  • createdBy (생성자)
  • updatedAt (수정일시)
  • updatedBy (수정자)
  • stcd (상태코드)

CHARACTER (Untitled6)

  • CHARACTER_ID (Key) — 기본 키 — NOT NULL
  • PROJECT_ID (Field)
  • name (Field2)
  • description (Field3)
  • age_range (Field4)
  • gender (Field5)
  • image_concept (Field6) — url
  • Field7

PROJECT (Untitled5)

  • PROJECT_ID (Key) — 기본 키 — NOT NULL
  • AGENCY_ID (Field)
  • title (Field2)
  • synopsis (Field3)
  • status (Field4)

USER (Untitled3)

  • USER_ID (Key) — 기본 키 — NOT NULL
  • user_uuid (Field)
  • userNm (Field3)
  • email (Field2)
  • password (Field4)
  • role (Field5) — ENUM
  • description (Field6)
  • age (나이대)
  • gender (Field7) — ENUM
  • profile (프로필사진주소) — url
  • phoneNumber (전화번호) — CHAR(10)
  • Field8

사진main (Untitled)

  • Key — 기본 키 — NOT NULL
  • Field
  • Field2