PICO - 제출용

테이블 (11)

Apply (지원)

  • apply_idx (Key) — bigint — 기본 키 — NOT NULL
  • estimate_idx (Key3) — bigint — 외래 키 → estimate.estimate_idx — NOT NULL
  • photographer_idx (Key4) — bigint — 외래 키 → photographer.photographer_idx — NOT NULL
  • status (Field6) — varchar
  • created (Field) — timestamp
  • is_applied (Field2) — Boolean

ChatRoom (채팅방)

  • chatRoom_idx (Key) — Long — 기본 키 — NOT NULL
  • user_idx (Key2) — bigint — 외래 키 → user.user_idx — NOT NULL
  • photographer_idx (Key3) — bigint — 외래 키 → photographer.photographer_idx — NOT NULL

category (Untitled)

  • category_idx (Key) — bigint — 기본 키 — NOT NULL
  • kind (title)

chatMessage (채팅메세지)

  • chatMessage_idx (Key) — Long — 기본 키 — NOT NULL
  • chatRoom_idx (Key2) — Long — 외래 키 → ChatRoom.chatRoom_idx — NOT NULL
  • user_idx (Key3) — bigint — 외래 키 → user.user_idx — NOT NULL
  • message (Field5) — varchar
  • created (Field) — timestamp

estimate (견적서)

  • estimate_idx (Key) — bigint — 기본 키 — NOT NULL
  • user_idx (Key2) — bigint — 외래 키 → user.user_idx — NOT NULL
  • category_idx (Key3) — bigint — 외래 키 → category.category_idx — NOT NULL
  • content (Field5) — varchar
  • created (Field2) — timestamp
  • city (Field6) — varchar
  • address (Field7) — varchar
  • startdate (Field4) — timestamp
  • enddate (Field8) — timestamp
  • status (Field) — varchar

p_category (작가 카테고리)

  • p_category_idx (Key) — bigint — 기본 키 — NOT NULL
  • photographer_idx (Key2) — bigint — 외래 키 → photographer.photographer_idx — NOT NULL
  • category_idx (Key3) — bigint — 외래 키 → category.category_idx — NOT NULL
  • kind (Field) — varchar

photo (사진)

  • photo_idx (Key) — bigint — 기본 키 — NOT NULL
  • work_idx (Key2) — bigint — 외래 키 → work.work_idx — NOT NULL
  • title (Field) — varchar
  • storedFilePath (Field2) — varchar
  • fileSize (Field3) — bigint
  • label (Field4)

photographer (작가)

  • photographer_idx (Key) — bigint — 기본 키 — NOT NULL
  • user_idx (Key2) — bigint — 외래 키 → user.user_idx — NOT NULL
  • is_studio (Field2) — bool
  • grade (Field4) — float
  • city (Field3) — varchar
  • address (Field5) — varchar
  • studioaddress (Field) — varchar
  • otherarea (Field6) — boolean

review (리뷰)

  • reivew_idx (Key) — 기본 키 — NOT NULL
  • user_idx (Key2) — bigint — 외래 키 → user.user_idx — NOT NULL
  • photographer_idx (Key3) — bigint — 외래 키 → photographer.photographer_idx — NOT NULL
  • created (Field2)
  • contents (Field3)
  • grade (Field4) — float

user (일반 유저)

  • user_idx (Key) — bigint — 기본 키 — NOT NULL
  • id (Field) — varchar
  • provider (Field2) — varchar
  • provider_id (Field3) — varchar
  • nickname (Field10) — varchar
  • name (Field4) — varchar
  • email (Field5) — varchar
  • phone (Field6) — varchar
  • role (Field7) — varchar
  • is_register (Field8) — bool
  • is_photographer (Field9) — bool

work (작품)

  • work_idx (Key) — bigint — 기본 키 — NOT NULL
  • photographer_idx (Key2) — bigint — 외래 키 → photographer.photographer_idx — NOT NULL
  • category_idx (Key3) — bigint — 외래 키 → category.category_idx — NOT NULL
  • title (Field) — varchar
  • content (Field3) — varchar
  • created (Field4) — varchar
  • thumbnail (Field5) — varchar