laundry_management

Tables (5)

customer (Untitled)

  • user_id (Key) — Long — Primary key — NOT NULL
  • owner_id (Key2) — Long — Foreign key → owner.owner_id — NOT NULL
  • name (Field) — String
  • phone (Field2) — String

owner (Untitled2)

  • owner_id (Key) — Long — Primary key — NOT NULL
  • diary_id (Key2) — Long — Foreign key → owner_daily_diary.diary_id — NOT NULL
  • StoreName (Field) — String
  • customers (Field3) — customer

owner

  • Key — Primary key — NOT NULL
  • Field

owner_daily_diary (Untitled4)

  • diary_id (Key) — Long — Primary key — NOT NULL
  • income (Field) — Long
  • date (Field2) — LocalDateTime

post (Untitled5)

  • post_id (Key) — Long — Primary key — NOT NULL
  • owner_id (Key2) — Long — Foreign key → owner.owner_id — NOT NULL
  • name (Field) — String
  • phone (Field2) — String
  • clothCount (Field3) — int
  • price (Field5) — int
  • content (Field4) — Lob
  • clothStatus (Field6) — String
  • createTime (생성시간) — LocalDateTime
  • updateTime (업데이트 시간)