근당

테이블 (11)

Category (category)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(100) — NOT NULL
  • create_id (t) — Timestamp — NOT NULL
  • updateTime (Field3) — Timestamp — NOT NULL

Chat (chat)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • chat_content (Field) — varchar(500)
  • chat_time (Field2) — Timestamp — NOT NULL
  • create_id (Field6) — Timestamp — NOT NULL
  • updateTime (Field7) — Timestamp — NOT NULL
  • first_user_id (Key2) — Bingint — 외래 키 → User.id — NOT NULL
  • second_user_id (Key3) — bigint — 외래 키 → User.id — NOT NULL
  • product_id (Key4) — Bigint — 외래 키 → Product.id — NOT NULL

Favorite (favorite)

  • Key — Bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • product_id (Key3) — bigint — 외래 키 → Product.id — NOT NULL
  • valid (Field) — boolean — NOT NULL
  • create_id (Field2) — Timestamp — NOT NULL
  • updateTime (Field3) — Timestamp — NOT NULL

Manner (manner)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • score (Field3) — float — NOT NULL
  • create_time (Field4) — Timestamp — NOT NULL
  • updateTime (Field5) — Timestamp — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • evaluation_id (Key3) — Bigint — 외래 키 → User.id — NOT NULL
  • ratingnum (Field) — int

Notification (notification)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • notification_content (Field) — varchar(150) — NOT NULL
  • notification_type (Field2) — int — NOT NULL
  • notification_time (Field3) — Timestamp — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL

Product (product)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • price (Field) — bigint — NOT NULL
  • title (Field2) — varchar(100) — NOT NULL
  • description (Field3) — varchar(250) — NOT NULL
  • location (Field4) — varchar(20) — NOT NULL
  • productState (Field5) — varchae(20) — NOT NULL
  • createTime (t) — Timestamp — NOT NULL
  • updateTime (Field7) — Timestamp — NOT NULL
  • image (Field6) — varchar(200) — NOT NULL
  • view_cnt (Field8) — int — NOT NULL
  • provider_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • category_id (Key4) — Bigint — 외래 키 → Category.id — NOT NULL

ProductImage (productimage)

  • Key — Bigint — 기본 키 — NOT NULL
  • product_id (Key2) — bigint — 외래 키 → Product.id — NOT NULL
  • image_url (Field) — varchar(200) — NOT NULL
  • createTime (Field2) — Timestamp — NOT NULL
  • updateTime (Field3) — Timestamp — NOT NULL

Review (review)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • create_id (Field2) — Timestamp — NOT NULL
  • content (Field) — varchar(100) — NOT NULL
  • updateTime (Field3) — Timestamp — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • product_id (Key3) — bigint — 외래 키 → Product.id — NOT NULL

Search (search)

  • Key — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • search_content (Field) — varchar(150)
  • search_time (Field2) — Timestamp — NOT NULL

Transaction (transaction)

  • id (Key) — Bigint — 기본 키 — NOT NULL
  • create_id (Field4) — Timestamp — NOT NULL
  • completed_time (Field5) — Timestamp — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
  • provider_id (Key3) — bigint — 외래 키 → User.id — NOT NULL
  • product_id (Key4) — bigint — 외래 키 → Product.id — NOT NULL

User (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • nickname (Field) — varchar(50) — NOT NULL
  • location (Field2) — varchar(20)
  • profileUrl (Field3) — varchar(250)
  • manner (Field4) — int
  • createTime (Field5) — Timestamp — NOT NULL
  • updateTime (Field6) — Timestamp — NOT NULL
  • email (Field7) — varchar(100) — NOT NULL
  • phone (Field8) — varchar(20) — NOT NULL
  • chat_num (Field9) — int — NOT NULL