dkdkk
Tables (9)
t_
- id — int — Primary key — NOT NULL
- product_id — int — NOT NULL
- status — int — 삭제 대비해서 넣음(공부 필요)
- like — int — 0-기본값(찜X),1-찜하기
t_GEclass
- id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
t_category
- id — int — Primary key — NOT NULL
- major_id — int — NOT NULL
- ge_id — int — NOT NULL
- elect_id — int — NOT NULL
t_comment
- id — int — Primary key — NOT NULL
- id2 — int — NOT NULL
- user_id — int — NOT NULL
- content — varchar — NOT NULL
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
t_elective
- id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
t_like
- id — int — Primary key — NOT NULL
- post_id — int — NOT NULL — like 값이 1인 것만 가져오기
- user_id — int — NOT NULL
t_major
- id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
t_product
- id — int — Primary key — NOT NULL
- title — varchar — NOT NULL
- product_name — varchar — NOT NULL
- product_price — int — NOT NULL
- content — varchar — NOT NULL
- tags — int — NOT NULL — 1-팔아요,2-살래요,3-나눠요
- trade_method — int — NOT NULL — 1-직거래,2-택배거래,3-사물함거래
- image_path — varchar — NOT NULL — 상품 사진
- created_time — datetime — NOT NULL
- modified_time — datetime — NOT NULL
- category_id — int — NOT NULL
- user_id — int — NOT NULL
t_user
- id — int — Primary key — NOT NULL
- name — varchar — NOT NULL
- type — int — NOT NULL — 1-buyer,2-seller
- email — varchar — NOT NULL — 숙명 메일만
- login_id — varchar — NOT NULL — ex) 로컬 로그인 가정
- nickname — varchar — NOT NULL
- password — varchar — NOT NULL