DB
Tables (20)
Admin (admin)
- id (PK) — Bigint — Primary key — NOT NULL
- 管理者 (admin) — Varchar(200)
- パスワード (password) — Varchar(200)
Answer (answer)
- id (PK) — Bigint — Primary key — NOT NULL
- QuestIon ID (question_id) — Bigint — Foreign key → Question.id — NOT NULL
- Seller ID (seller_id) — Bigint — Foreign key → Seller.id — NOT NULL
- Admin ID (admin_id) — Bigint — Foreign key → Admin.id — NOT NULL
- 内容 (content) — Varchar(20000)
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Ban
- id (PK) — Bigint — Primary key — NOT NULL
- Seller ID (seller_id) — Bigint — Foreign key → Seller.id — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- 事由 (reason) — Varchar(200)
- ステータス (status) — Tinyint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Buyer (buyer)
- id (PK) — Bigint — Primary key — NOT NULL
- ユーザーメール (email) — Varchar(200)
- パスワード (password) — Varchar(200)
- ニックネーム (nickname) — Varchar(200)
- お名前 (name) — Varchar(200)
- 電話番号 (phone_number) — Bigint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Buyer_address (buyer_address)
- id (PK) — Bigint — Primary key — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- 郵便番号 (post_number) — Varchar(2000)
- 都道府県 (prefecture) — Varchar(2000)
- 市区町村 (city) — Varchar(2000)
- ステータス (status) — Tinyint
- 作成時間 (created_at) — TIMESTAMP
- 丁目・番地・号 (block_number) — Varchar(2000)
- 建物名/会社名・部屋番号 (building_name) — Varchar(2000)
Cart (cart)
- id (PK) — Bigint — Primary key — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- Option ID (option_id) — Bigint — Foreign key → Option.id — NOT NULL
- 数量 (amount) — Bigint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Category (category)
- id (PK) — Bigint — Primary key — NOT NULL
- カテゴリーネーム (category_name) — Varchar(200)
Category_detail (category_detail)
- id (PK) — Bigint — Primary key — NOT NULL
- Category ID (categroy_id) — Bigint — Foreign key → Category.id — NOT NULL
- カテゴリーディテールネーム (category_detail_name) — Varchar(200)
Notice (notice)
- id (PK) — Bigint — Primary key — NOT NULL
- Admin ID (admin_id) — Bigint — Foreign key → Admin.id — NOT NULL
- タイトル (title) — Varchar(2000)
- 内容 (content) — Varchar(20000)
- picture_url (notice_picture_url) — Varchar(20000) — NOT NULL
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Notice_picture (notice_pic)
- id (PK) — Bigint — Primary key — NOT NULL
- Notice ID (notice_id) — Bigint — Foreign key → Notice.id — NOT NULL
- Notice Picture Url (notice_image_url) — Varchar(2000)
- 作成時間 (created_at) — TIMESTAMP
Option
- id (PK) — Bigint — Primary key — NOT NULL
- オプションネーム (option_name) — Varchar(200)
- Product ID (product_id) — Bigint — Foreign key → Product.id — NOT NULL
Order (order)
- id (PK) — Bigint — Primary key — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- Option ID (option_id) — Bigint — Foreign key → Option.id — NOT NULL
- Payment ID (payment_id) — Bigint — Foreign key → payment.id — NOT NULL
- 受け取り人 (receiver) — Varchar(200)
- 住所 (address) — Varchar(2000)
- 電話番号 (phone_number) — Varchar(2000)
- ステータス (status) — Tinyint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
- 数量 (amount) — Bigint
Product (products)
- id (PK) — Bigint — Primary key — NOT NULL
- Seller ID (seller_id) — Bigint — Foreign key → Seller.id — NOT NULL
- Category ID (category_id) — Bigint — Foreign key → Category.id — NOT NULL
- Category Detail ID (category_detail_id) — Bigint — Foreign key → Category_detail.id — NOT NULL
- タイトル (title) — Varchar(2000)
- 内容 (content) — Varchar(60000)
- 値段 (price) — Bigint
- thumbnail_url — Varchar(2000)
- ステータス (status) — Tinyint
- 数量 (amount) — Bigint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Product_notice (product_notice)
- id (PK) — Bigint — Primary key — NOT NULL
- Seller ID (seller_id) — Bigint — Foreign key → Seller.id — NOT NULL
- Product ID (product_id) — Bigint — Foreign key → Product.id — NOT NULL
- タイトル (title) — Varchar(2000)
- 内容 (content) — Varchar(20000)
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Product_picture (product_pic)
- id (PK) — Bigint — Primary key — NOT NULL
- Product ID (product_id) — Bigint — Foreign key → Product.id — NOT NULL
- Product Picture Url (product_image_url) — Varchar(60000)
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Question (question)
- id (PK) — Bigint — Primary key — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- Seller ID (seller_id) — Bigint — Foreign key → Seller.id — NOT NULL
- Admin ID (admin_id) — Bigint — Foreign key → Admin.id — NOT NULL
- タイトル (title) — Varchar(2000)
- 内容 (content) — Varchar(20000)
- ステータス (status) — Tinyint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Review (reviews)
- id (PK) — Bigint — Primary key — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- Product ID (product_id) — Bigint — Foreign key → Product.id — NOT NULL
- 内容 (content) — Varchar(2000)
- 評価 (rating) — Bigint
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Seller (seller)
- id (PK) — Bigint — Primary key — NOT NULL
- ユーザーメール (email) — Varchar(200)
- パスワード (password) — Varchar(200)
- お名前 (name) — Varchar(200)
- 会社名 (company_name) — Varchar(200)
- 会社住所 (company_address) — Varchar(200)
- 口座 (bank_account) — Bigint
- 銀行名 (bank_name) — Varchar(200)
- 業種 (category_id) — Bigint — Foreign key → Category.id — NOT NULL
- 作成時間 (created_at) — TIMESTAMP
- 修正時間 (updated_at) — TIMESTAMP
Wishlist (wishlist)
- id (PK) — Bigint — Primary key — NOT NULL
- Product ID (product_id) — Bigint — Foreign key → Product.id — NOT NULL
- Buyer ID (buyer_id) — Bigint — Foreign key → Buyer.id — NOT NULL
- 作成時間 (created_at) — TIMESTAMP
payment (CopyOfcategory_detail)
- id (PK) — Bigint — Primary key — NOT NULL
- total_price — bigint
- payment_number — bigint
- approvedAt (approved_at) — Varchar(2000)