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