라라벨 프로젝트

테이블 (11)

Customer (거래처(협력사))

  • customer_id — bigint — 기본 키 — NOT NULL
  • customer_name — varchar
  • business_registeration_no — varchar
  • customer_address — varchar
  • charger — varchar
  • charger_phone — varchar
  • created_at — timestamp
  • updated_at — timestamp

Notice (게시판)

  • notice_id — bigint — 기본 키 — NOT NULL
  • user_id (user_Id) — bigint — 외래 키 → User.user_id — NOT NULL
  • title — varchar
  • contents — longtext
  • category — varchar
  • hits — int
  • status — char
  • created_at — timestamp
  • updated_at (updateed_at) — timestamp

NoticeComment (게시판 댓글)

  • notice_comment_id — bigint — 기본 키 — NOT NULL
  • notice_id — bigint — 외래 키 → Notice.notice_id — NOT NULL
  • user_id (user_Id) — bigint — 외래 키 → User.user_id — NOT NULL
  • comment — text
  • created_at — timestamp
  • updated_at — timestamp

NoticeFile (게시판 첨부파일)

  • notice_file_id — bigint — 기본 키 — NOT NULL
  • notice_id — bigint — 외래 키 → Notice.notice_id — NOT NULL
  • file_path — varchar
  • saved_file — varchar
  • origin_file — varchar

Order (주문)

  • order_id — bigint — 기본 키 — NOT NULL
  • user_id (user_Id) — bigint — 외래 키 → User.user_id — NOT NULL
  • order_status — int
  • total_price — int
  • created_at — timestamp

OrderDetail (주문상세)

  • order_detail_id — bigint — 기본 키 — NOT NULL
  • order_id — bigint — 외래 키 → Order.order_id — NOT NULL
  • product_id — bigint — 외래 키 → Product.product_id — NOT NULL

OrderHistory (주문서 배송 상태 변경 내역)

  • order_id — bigint — 외래 키 → Order.order_id — NOT NULL
  • created_at — timestamp

Product (상품)

  • product_id — bigint — 기본 키 — NOT NULL
  • customer_id — bigint — 외래 키 → Customer.customer_id — NOT NULL
  • product_name — varchar
  • product_status — int
  • price — int
  • purchase_price — price
  • hits — int
  • created_at — timestamp
  • updated_at — timestamp

ProductFile (상품이미지)

  • product_file_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 → Product.product_id — NOT NULL
  • file_path — varchcar
  • saved_file — varchar
  • origin_file — varchar

User (유저)

  • user_id (user_Id) — bigint — 기본 키 — NOT NULL
  • id — varchar
  • password — varchar
  • name — varchar
  • address — varchar
  • address2 — varchar
  • email — varchar
  • phone — varchar
  • grade — int
  • created_at — timestamp
  • updated_at — timestamp

UserLoginHistory (유저 로그인 기록)

  • user_login_history_id — bigint — 기본 키 — NOT NULL
  • user_id (user_Id) — bigint — 외래 키 → User.user_id — NOT NULL
  • login_ip — varchar
  • created_at — timestamp