flowering_pjt

Tables (17)

Consultant

  • consultant_id (Key) — Long — Primary key — NOT NULL
  • review_count — int

Customer

  • customer_id (Key) — Long — Primary key — NOT NULL
  • 예약 (reservations)
  • 컨설팅 (consulting)

FAQ

  • faq_id (Key) — Long — Primary key — NOT NULL
  • question — varchar(200)
  • answer — varchar(200)

Magazine

  • Magazine_id (PK) — Long — Primary key — NOT NULL
  • admin_id (Field3) — Long — Foreign key → admin.admin_id
  • title (Field) — varchar(200)
  • contents — varchar(200)

Reservation

  • reservation_id — Primary key — NOT NULL
  • consultant_id (fk) — Long — Foreign key → Consultant.consultant_id — NOT NULL
  • customer_id (Key3) — Long — Foreign key → Customer.customer_id — NOT NULL
  • time — time
  • request — varchar(200)
  • created_date — timestamp
  • purpose — Enum
  • date — date

Role

  • customer
  • admin
  • consultant

SkinType

  • dry
  • oily

User

  • id — Long — Primary key — NOT NULL
  • role — Enum
  • email — varchar(200)
  • department — varchar(200)
  • name — varchar(200)
  • password — varchar(200)
  • createAt — LocalDateTime
  • provider — AuthProvider
  • status — UserStatus

admin

  • admin_id (pk) — Long — Primary key

community

  • community_id (Key) — Long — Primary key — NOT NULL
  • customer_id (Key2) — Long — Foreign key → Customer.customer_id — NOT NULL
  • time — time
  • date — date
  • created_date — timestamp

consultingResult

  • consultingResult_id (pk) — Long — Primary key — NOT NULL
  • sessionId — varchar(200)
  • comment — varchar(200)
  • Field

cosulting

  • cosulting_id (Key) — Long — Primary key — NOT NULL
  • consultant_id (Key2) — Long — Foreign key → Consultant.consultant_id — NOT NULL
  • consultingResult_id (Key3) — Long — Foreign key → consultingResult.consultingResult_id — NOT NULL
  • customer_id (Key4) — Long — Foreign key → Customer.customer_id — NOT NULL
  • created_date — timestamp
  • price — Long

customercommunity

  • usercommunity_id (Key) — Long — Primary key — NOT NULL
  • community_id (Key2) — Long — Foreign key → community.community_id — NOT NULL
  • customer_id (Key3) — Long — Foreign key → Customer.customer_id — NOT NULL

mycart

  • mycart_id (Key) — Long — Primary key — NOT NULL
  • cosulting_id (Key2) — Long — Foreign key → cosulting.cosulting_id — NOT NULL
  • consultant_id (Key22) — Long — Foreign key → cosulting.consultant_id — NOT NULL
  • consultingResult_id (Key3) — Long — Foreign key → cosulting.consultingResult_id — NOT NULL
  • customer_id (Key4) — Long — Foreign key → cosulting.customer_id — NOT NULL

notify

  • notify_id (Key) — Long — Primary key — NOT NULL
  • admin_id (FK) — Long — Foreign key → admin.admin_id
  • title — varchar(200)
  • contents — varchar(200)

purpose

  • 커뮤니티 (community)
  • 컨설팅 (consulting)

survey

  • survey_id — Long — Primary key — NOT NULL
  • customer_id (Key2) — Long — Foreign key → Customer.customer_id — NOT NULL
  • SkinType — enum