근당
테이블 (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