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)