라라벨 프로젝트
테이블 (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