MiniPictory

Tables (14)

Adjustment (정산)

  • id (Key) — Long — Primary key — NOT NULL
  • adjustAmount (Field) — Int
  • bank (Field2) — String
  • adjustDate (Field3) — Date
  • userId (Field4) — Long
  • createdate (Field5) — Date
  • updatedat (Field6) — Date

Alarm (알람)

  • id (Key) — Long — Primary key — NOT NULL
  • alarmType (Field) — String
  • alarmDateTime (Field2) — Date
  • isChecked (Field3) — Int
  • receiver (Field4) — String
  • sender (Field5) — String
  • subject (Field6) — String
  • content (Field7) — String
  • updatedat (Field8) — Long
  • createdat (Field9) — Long

Cart (장바구니)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Field) — Long
  • goodsId (Field2) — Long

Chat (채팅)

  • id (Key) — Long — Primary key — NOT NULL
  • message (Field) — String
  • receiver (Field2) — String
  • sender (Field3) — String
  • createdat (Field4) — Date
  • updatedat (Field5) — Date

Comment (댓글)

  • id (Key) — Long — Primary key — NOT NULL
  • goodsNo (Field) — Int
  • userNo (Field2) — Int
  • comment (Field3) — String
  • id (Key2) — Long — Foreign key → Goods.id — NOT NULL

Follow (팔로우)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → Users.id — NOT NULL
  • followingId (Field3) — String
  • createdat (Field4) — Date
  • updatedat (Field5) — Date

Goods (상품)

  • id (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • url (Field2) — String
  • price (Field3) — Int
  • status (Field4) — String
  • createdat (Field5) — Date
  • updatedat (Field6) — Date

Hashtag (해쉬태그)

  • id (Key) — Long — Primary key — NOT NULL
  • hashTag (Field2) — String
  • createdat (Field3) — Date
  • updatedat (Field4) — Date
  • id (Key2) — Long — Foreign key → Goods.id — NOT NULL

Likes (좋아요)

  • id (Key) — Long — Primary key — NOT NULL
  • userNo (Field) — Int
  • goodsNo (Field2) — Int
  • createdat (Field3) — Date
  • updatedat (Field4) — Date
  • id (Key2) — Long — Foreign key → Goods.id — NOT NULL

Order (주문)

  • id (Key) — Long — Primary key — NOT NULL
  • userId (Field2) — Long
  • createdat (Field3) — Date
  • updatedat (Field4) — Date
  • paymentId (Key2) — Long — Foreign key → Payment.id — NOT NULL

OrderGoods (Untitled)

  • id (Key) — Long — Primary key — NOT NULL
  • orderId (Key2) — Long — Foreign key → Order.id — NOT NULL
  • goodsId (Field2) — Long
  • createdat (Field) — Date
  • updatedat (Field3) — Date

Payment (구매)

  • id (Key) — Long — Primary key — NOT NULL
  • paymentDateTime (Field) — Date
  • totalPrice (Field2) — Int
  • createdat (Field3) — Date
  • updatedat (Field4) — Date

Qna (문의)

  • id (Key) — Long — Primary key — NOT NULL
  • loginId (Field) — String
  • title (Field2) — String
  • content (Field3) — String
  • createdat (Field4) — Date
  • updatedat (Field5) — Date

Users (회원)

  • id (Key) — Long — Primary key — NOT NULL
  • loginId (Field) — String
  • password (Field2) — String
  • email (Field3) — String
  • name (Field4) — String
  • nickName (Field5) — String
  • profileImg (Field8) — String
  • self (Field9) — String
  • createdat (Field10) — Date
  • updatedat (Field11) — Date