inha-project

Tables (30)

Copy Of user_image (user_notification)

  • Key (user_notification_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • url (title) — varchar — NOT NULL
  • Field (body) — varchar
  • Field (wherCreated) — timestamp

Untitled (category_manufacturer)

  • Key (category_manufacturer_id) — int — Primary key — NOT NULL
  • category_id — int — Foreign key → category.category_id — NOT NULL
  • manufacturer_id — int — Foreign key → manufacturer.manufacturer_id — NOT NULL

Untitled (penalty_deposit)

  • Key (deposit_id) — int — Primary key — NOT NULL
  • Field (depositor_name) — varchar — NOT NULL
  • Field (depositor_amount) — int — NOT NULL
  • Field (deposit_check) — enum — NOT NULL

Untitled (inspection_image)

  • inspection_id — int — Foreign key → inspection.inspection_id — NOT NULL
  • deal_id — int — Foreign key → inspection.deal_id — NOT NULL
  • Field (url) — varchar — NOT NULL

auctionitem

  • auctionitem_id — int — Primary key — NOT NULL
  • item_id — int — Foreign key → item.item_id — NOT NULL
  • price — Money — NOT NULL

buying

  • buying_id — int — Primary key — NOT NULL
  • payment_id — int — Foreign key → payment.payment_id — NOT NULL
  • buying_status — enum — NOT NULL
  • Field (end_date) — timestamp

category

  • category_id — int — Primary key — NOT NULL
  • category_name — varchar — NOT NULL

deal

  • deal_id — int — Primary key — NOT NULL
  • buying_id — int — Foreign key → buying.buying_id — NOT NULL
  • selling_id — int — Foreign key → selling.selling_id — NOT NULL
  • deal_status — enum — NOT NULL

fail_delivery

  • fail_delivery_id — int — Primary key — NOT NULL
  • inspection_id — int — Foreign key → fail_inspection.inspection_id — NOT NULL
  • courier_name — enum — NOT NULL
  • invoice_number — varchar — NOT NULL
  • Field (seller_city) — varchar — NOT NULL
  • Field (seller_street) — varchar — NOT NULL
  • Field (seller_detail) — varchar — NOT NULL
  • Field (seller_zipcode) — varchar — NOT NULL
  • Field (deliveryStatus) — enum

fail_inspection

  • Key (deposit_id) — int — Foreign key → Untitled.Key — NOT NULL
  • inspection_id — int — Foreign key → inspection.inspection_id — NOT NULL

inspection

  • inspection_id — int — Primary key — NOT NULL
  • deal_id — int — Foreign key → deal.deal_id — NOT NULL

item

  • item_id — int — Primary key — NOT NULL
  • category_id — int — Foreign key → category.category_id — NOT NULL
  • manufacturer_id — int — Foreign key → manufacturer.manufacturer_id — NOT NULL
  • item_name — varchar — NOT NULL
  • model_number — varchar — NOT NULL
  • release_price — int — NOT NULL
  • like (like_count) — int — NOT NULL
  • market_price — int — NOT NULL
  • Field (lowest_price) — int

item_image

  • item_id — int — Foreign key → item.item_id — NOT NULL
  • url (file_name) — varchar — NOT NULL
  • Field (file_ori_name) — varchar
  • Field (file_url) — varchar

manufacturer

  • manufacturer_id — int — Primary key — NOT NULL
  • manufacturer_name — varchar — NOT NULL

pass_delivery

  • pass_delivery_id — int — Primary key — NOT NULL
  • inspection_id — int — Foreign key → pass_inspection.inspection_id — NOT NULL
  • courier_name — enum — NOT NULL
  • invoice_number — varchar — NOT NULL
  • Field (buyer_city) — varchar — NOT NULL
  • Field (buyer_street) — varchar — NOT NULL
  • Field (buyer_detail) — varchar — NOT NULL
  • Field (buyer_zipcode) — varchar — NOT NULL

pass_inspection

  • inspection_id — int — Foreign key → inspection.inspection_id — NOT NULL

payment

  • payment_id — int — Primary key — NOT NULL
  • auctionitem_id — int — Foreign key → auctionitem.auctionitem_id — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • item_id — int — Foreign key → item.item_id — NOT NULL
  • payment_price — int — NOT NULL
  • Field (merchant_id) — int — NOT NULL
  • Field (imp_id) — int
  • Field (pg_name) — varchar
  • Field (cancel_price) — int
  • Field (point) — int
  • Field (payment_status) — enum

selling

  • selling_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • selling_delivery_id — int — Foreign key → selling_delivery.selling_delivery_id — NOT NULL
  • auctionitem_id — int — Foreign key → auctionitem.auctionitem_id — NOT NULL
  • selling_status — enum — NOT NULL
  • Field (end__date) — timestamp

selling_delivery

  • selling_delivery_id — int — Primary key — NOT NULL
  • courierName (courier_name) — enum — NOT NULL
  • invoice_number — varchar — NOT NULL

settlement

  • settlement_id — int — Primary key — NOT NULL
  • inspection_id — int — Foreign key → pass_inspection.inspection_id — NOT NULL
  • seller_name (seller_id) — int — NOT NULL
  • auctionitem_name (auctionitem_id) — int — NOT NULL
  • auctionitem_price — int — NOT NULL
  • settlement_price — int — NOT NULL
  • Field (deal_id) — int
  • Field (bank_name) — varchar
  • Field2 (account_number) — varchar
  • Field3 (account_holder) — varchar

user

  • user_id — int — Primary key — NOT NULL
  • Field (user_account_id) — int — Foreign key → user_account.Field
  • Key (user_image_id) — int — Foreign key → user_image.Key — NOT NULL
  • user_name — varchar — NOT NULL
  • nickname — varchar
  • email — varchar — NOT NULL
  • user_tel — varchar — NOT NULL
  • Field (password) — varchar

user_account

  • Field (user_account_id) — int — Primary key
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • bank_name — enum — NOT NULL
  • account_number — varchar — NOT NULL
  • title (accountHolder) — varchar

user_address

  • Key (user_address_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • city — varchar — NOT NULL
  • street — varchar — NOT NULL
  • zipcode — varchar — NOT NULL
  • title (detail) — varchar — NOT NULL
  • Field (recipient) — varchar
  • Field2 (contactTel) — varchar

user_card_info

  • Key (user_card_info_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • card_company_name — enum — NOT NULL
  • card_number — varchar — NOT NULL

user_image

  • Key (user_image_id) — int — Primary key — NOT NULL
  • url (file_url) — varchar — NOT NULL
  • Field (file_ori_name) — varchar
  • Field (file_name) — varchar

user_inquiry

  • inquiry_id (user_inquiry_id) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • type (inquiry_type) — enum — NOT NULL
  • title — varchar — NOT NULL
  • content — varchar — NOT NULL
  • Field (inquiry_status) — enum — NOT NULL

user_inquiry_answer

  • Key (user_inquiry_answer_id) — int — Primary key — NOT NULL
  • inquiry_id (user_inquiry_id) — int — Foreign key → user_inquiry.inquiry_id — NOT NULL
  • content — varchar — NOT NULL

user_inquiry_image

  • Key (user_inqury_image_id) — int — Primary key — NOT NULL
  • inquiry_id (user_inquiry_id) — int — Foreign key → user_inquiry.inquiry_id — NOT NULL
  • url (file_url) — varchar — NOT NULL
  • Field (file_name) — varchar
  • Field (file_ori_name) — varchar

user_like_item

  • user_id — int — Foreign key → user.user_id — NOT NULL
  • item_id — int — Foreign key → item.item_id — NOT NULL

user_point

  • user_point_id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → user.user_id — NOT NULL
  • total — int — NOT NULL
  • used — int — NOT NULL
  • earned — int — NOT NULL