백엔드
테이블 (12)
Baskets
- ID — bigint — 기본 키 — NOT NULL
- ID (ID2) — bigint — 외래 키 → Users.ID — NOT NULL
- ID (ID3) — bigint — 외래 키 → Products.ID — NOT NULL
- created_date — varchar(255)
- productName — varchar(255)
- productStatus — varchar(255)
- quantity — bigint
- ID (product_id) — bigint
- update_date — varchar(255)
- user_id — bigint
BeginOrder
- ID — bigint — 기본 키 — NOT NULL
- ID (ID2) — bigint — 외래 키 → Orders.ID — NOT NULL
- created_date — varchar(255)
- picture — varchar(255)
- quantity — bigint
- update_date — varchar(255)
- order_id — bigint
- product_id — bigint
Category
- ID — bigint — 기본 키 — NOT NULL
- categoryName — varchar(255)
- created_date — varchar(255)
- update_date — varchar(255)
- category_id — bigint
- ID (product_id) — bigint — NOT NULL
Comment
- id — bigint — 기본 키 — NOT NULL
- ID — bigint — 외래 키 → Notice.ID — NOT NULL
- ID (ID3) — bigint — 외래 키 → Users.ID — NOT NULL
- contents — varchar(255)
- created_date — varchar(255)
- userName — varchar(255)
- notice_id — bigint
- user_id — bigint
File
- ID — bigint — 기본 키 — NOT NULL
IpAddress
- ID — bigint — 기본 키 — NOT NULL
- Ip — varchar(255)
Message (CopyOfRoom)
- ID — bigint — 기본 키 — NOT NULL
- roomId — varchar(255) — 외래 키 → Room.ID — NOT NULL
- Ip — varchar(255)
- createdAt — TimeStamp
- sender — varchar(255)
- text — varchar(255)
Notice
- ID — bigint — 기본 키 — NOT NULL
- ID (ID2) — bigint — 외래 키 → Users.ID — NOT NULL
- contents — varchar(255)
- created_date — varchar(255)
- email — varchar(255)
- title — varchar(255)
- username — varchar(255)
- user_id — bigint
Orders
- ID — bigint — 기본 키 — NOT NULL
- ID (ID2) — bigint — 외래 키 → Users.ID — NOT NULL
- cancel — boolean — NOT NULL
- created_date — varchar(255)
- payment — varchar(255)
- price — bigint
- status — varchar(255)
- update_date — varchar(255)
- user_id — bigint
Products
- ID — bigint — 기본 키 — NOT NULL
- ID (ID2) — bigint — 외래 키 → Category.ID — NOT NULL
- created_date — varchar(255)
- describe — varchar(255)
- picture — varchar(255)
- price — bigint
- productName — varchar(255)
- sold_out — boolean
- update_date — varchar(255)
- category_id — bigint
Room
- ID — bigint — 기본 키 — NOT NULL
- roomId — varchar(255) — 기본 키 — NOT NULL
- Ip — varchar(255)
- createdAt — TimeStamp
Users
- ID — bigint — 기본 키 — NOT NULL
- email — varchar(255)
- level — bigint — NOT NULL
- name — varchar(255)
- password — varchar(255)
- username — varchar(255)