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