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