Team G4U
Tables (12)
Alarm (알람)
- alarm_id (알림 아이디) — INT — Primary key — NOT NULL
- funding_id (펀딩 아이디) — INT — Foreign key → Funding.funding_id — NOT NULL
- contents (내용) — TEXT — NOT NULL
- is_read (알림 읽음 여부) — BIT — NOT NULL
- created_at (알림 발송 날짜) — DATETIME — NOT NULL
- product_id (상품번호2) — INT — Foreign key → Funding.product_id — NOT NULL
Delivery_Address (배송지)
- delever_id (배송지번호) — INT — Primary key — NOT NULL
- user_id (유저번호) — INT — Foreign key → User.user_id — NOT NULL
- zipcode (우편번호) — INT
- address (주소) — VARCHAR
Follow (친구목록)
- friendlist_id (식별번호) — INT — Primary key — NOT NULL
- user_id (로그인한 유저 user_id) — INT — Foreign key → User.user_id — NOT NULL
- follow_id (추가한 친구의 user_id) — INT — NOT NULL
Funding (펀딩)
- funding_id (펀딩 아이디) — INT — Primary key — NOT NULL
- product_id (상품번호) — INT — Foreign key → Product.product_id — NOT NULL
- user_id (펀딩 시작한 사람 PK 번호) — INT — NOT NULL
- target_id (펀딩 받는 사람 번호) — INT — NOT NULL
- product_price (목표 금액) — INT — NOT NULL
- funded_price (누적 펀딩된 가격) — INT — NOT NULL
- fund_status (진행 상태) — VARCHAR — NOT NULL
- start_date (시작일) — DATETIME — NOT NULL
- end_date (종료일) — DATETIME — NOT NULL
Funding_Participation (펀딩참여)
- participant_id (펀딩 참여 아이디) — INT — Primary key — NOT NULL
- funding_id (펀딩 아이디) — INT — Foreign key → Funding.funding_id — NOT NULL
- user_id (유저번호) — INT — Foreign key → User.user_id — NOT NULL
- price (지불한 금액) — INT — NOT NULL
- funded_at (펀딩한 날짜) — DATETIME — NOT NULL
Like (추천수)
- product_id (상품번호) — INT — Foreign key → Product.product_id — NOT NULL
- like (추천 수) — INT
Order (주문)
- order_id (주문번호) — INT — Primary key — NOT NULL
- funding_id (펀딩 아이디) — INT — Foreign key → Funding.funding_id — NOT NULL
- product_id (상품번호2) — INT — Foreign key → Funding.product_id — NOT NULL
- target_id (수신자) — INT — NOT NULL
- address (주소) — VARCHAR — NOT NULL
- status (처리상태) — VARCHAR
Order_History (주문내역)
- history_id (주문 이력 아이디) — INT — Primary key — NOT NULL
- order_id (주문번호) — INT — Foreign key → Order.order_id — NOT NULL
- funding_id (펀딩 아이디) — INT — Foreign key → Order.funding_id — NOT NULL
- product_id (상품번호2) — INT — Foreign key → Order.product_id — NOT NULL
Product (상품)
- product_id (상품번호) — INT — Primary key — NOT NULL
- name (상품명) — VARCHAR — NOT NULL
- product_image (상품 이미지) — VARCHAR — NOT NULL
- category (카테고리) — VARCHAR — NOT NULL
- price (가격) — INT — NOT NULL
- description (설명) — TEXT — NOT NULL
- is_best (베스트 여부) — BIT — NOT NULL
- created_at (등록일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME — NOT NULL
ReView (한줄평)
- product_id (상품번호) — INT — Foreign key → Product.product_id — NOT NULL
- user_name (작성자 이름) — VARCHAR — NOT NULL
- review (한줄평) — TEXT — NOT NULL
User (사용자)
- user_id (유저번호) — INT — Primary key — NOT NULL
- name (이름) — VARCHAR — NOT NULL
- nick_name (닉네임) — VARCHAR — NOT NULL
- email (이메일) — VARCHAR — NOT NULL
- password (비밀번호) — VARCHAR — NOT NULL — 회원 비밀번호
- point_price (포인트) — INT — NOT NULL
- phone (연락처) — VARCHAR — NOT NULL
- is_influencer (인플루언서 여부) — BIT — NOT NULL
- profile_image (유저 사진(파일 경로)) — VARCHAR — NOT NULL
- user_roles (유저권한) — BIT — NOT NULL
- user_status (유저상태) — BIT — NOT NULL
- created_at (생성일) — DATETIME — NOT NULL
- updated_at (수정일) — DATETIME
WishList (찜목록)
- wishlist_id (찜목록번호) — INT — Primary key — NOT NULL
- user_id (유저번호) — INT — Foreign key → User.user_id — NOT NULL
- funding_id (펀딩 아이디) — INT — Foreign key → Funding.funding_id
- product_id (상품번호) — INT — Foreign key → Funding.product_id — NOT NULL