test_myinfo
테이블 (18)
Address
- addr_idx — int — 기본 키 — NOT NULL
- 회원번호 (mem_idx) — int — 외래 키 → 회원.회원번호 — NOT NULL
- zipcode — int — NOT NULL
- addr_street — varchar(255) — NOT NULL
- addr_detail — varchar(255)
brand
- brand_idx — int — NOT NULL
- brand_name — VARCHAR(255) — NOT NULL
cart
- cart_idx — int — NOT NULL
- goods_idx — int
- product_count — int
- is_deleted — INT
- 회원번호 (mem_idx) — int — 외래 키 → 회원.회원번호 — NOT NULL
categories
- Key (cate_id) — int — 기본 키 — NOT NULL
- cate_name — varchar(200) — NOT NULL
- cate_parent_id — int
- Key (cate_id2) — int — 외래 키 → categories.Key — NOT NULL
comments
- 회원번호 (mem_idx) — int — 외래 키 → 회원.회원번호 — NOT NULL
- cmt_idx — int_auto_increment — NOT NULL
- b_idx — int — NOT NULL
- cmt_content — text — NOT NULL
- cmt_ip — varchar(200) — NOT NULL
- cmt_regdate — datetime
- mem_id — varchar(200)
- mem_name — varchar(200)
- mem_mask_id — varchar(200)
- no — int
delivery
- Key — VARCHAR(255) — NOT NULL
filter
- filter_idx — int — NOT NULL
- Field — VARCHAR(255)
goods
- goods_idx — int — 기본 키 — NOT NULL
- cate_id — int — NOT NULL
- goods_name — varchar(255)
- goods_contents — text
- goods_price — int
- goods_Rate — int
- goods_rate_price — int
- goods_quantity — int
- release_date — date
- goods_brand — varchar(100)
- image_url — varchar(255)
- goods_rating — int
- goods_reviews — int
- goods_availability — tinyint(1)
- sale_start_date — date
- sale_end_date — date
- able_minors_buy — boolean — NOT NULL
- country — varchar(100)
- reg_date — datetime
- mod_date — datetime
- 회원번호 (mem_idx) — int — 외래 키 → 회원.회원번호 — NOT NULL
- Key (cate_id2) — int — 외래 키 → categories.Key — NOT NULL
kakaologin
- kakao_idx — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- Field2 — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone_number — VARCHAR(255) — NOT NULL
- age_range — VARCHAR(255) — NOT NULL
- birthyear — VARCHAR(255) — NOT NULL
- birthday — VARCHAR(255)
- birthday_type — VARCHAR(255)
- gender — VARCHAR(255)
location
- loca_idx — int — NOT NULL
- Field — VARCHAR(255)
payment
- payment_idx — int — NOT NULL
- mem_idx — int — NOT NULL
- goods_idx — INT
- product_count — INT
- goods_name — VARCHAR(255)
- goods_price — INT
- goods_brand — VARCHAR(255)
- image_url — VARCHAR(255)
- country — VARCHAR(255)
- orderId — VARCHAR(255)
- isPartialCancelable — BOOLEAN
- suppliedAmount — INT
- type — VARCHAR(50)
- currency — VARCHAR(50)
- method — VARCHAR(50)
- vat — INT
- deliveryFee — INT
- approvedAt — DATETIME
- totalAmount — INT
- status — VARCHAR(50)
- goods_count_rate_price — int
- goods_count_price — int
support
- 회원번호 (mem_idx) — int — 외래 키 → 회원.회원번호 — NOT NULL
- 회원번호 (mem_idx2) — int — 외래 키 → comments.회원번호 — NOT NULL
- b_idx — int — NOT NULL
- b_subject — varchar(45) — NOT NULL
- b_content — text — NOT NULL
- b_ip — varchar(45) — NOT NULL
- b_regdate — datetime
- b_readhit — int
- mem_name — varchar(200) — NOT NULL
- b_ref — int
- b_step — int
- b_depth — int
- b_use — varchar(10)
- no — int
- cmt_count — int
- community_page — int
ticket
- ticket_idx — int — NOT NULL
- ticket_name — VARCHAR(255) — NOT NULL
- ticket_startdate — VARCHAR(255) — NOT NULL
- ticket_enddate — VARCHAR(255) — NOT NULL
- ticket_discount — VARCHAR(255)
상품이미지(현재 사용되지 않음) (image)
- Key (b_idx) — int — 기본 키 — NOT NULL
- goods_idx — int
- image_url — VARCHAR(200)
입고 테이블 (inventory_in)
- Key (in_idx) — int — 기본 키 — NOT NULL
- goods_idx — int — 외래 키 → 재고 테이블.goods_idx — NOT NULL
- Field — varchar(255) — NOT NULL
- in_cnt — int — NOT NULL
- in_ergdate — date
재고 테이블 (inventory_remain)
- Key (remain_idx) — int — 기본 키 — NOT NULL
- goods_idx — int — 외래 키 → goods.goods_idx — NOT NULL
- remain_name — varchar(255) — NOT NULL — unique(name)
- remain_cnt — int — NOT NULL
- remain_regdate — date
출고 테이블 (inventory_out)
- out_idx — int — 기본 키 — NOT NULL
- goods_idx — int — 외래 키 → 재고 테이블.goods_idx — NOT NULL
- out_name — varchar(255) — NOT NULL
- out_cnt — int — NOT NULL
- out_regdate — date
회원 (member)
- 회원번호 (mem_idx) — int — 기본 키 — NOT NULL
- mem_name — varchar(100) — NOT NULL
- mem_id — varchar(100) — NOT NULL
- mem_pwd — varchar(100) — NOT NULL
- mem_birth — date — NOT NULL
- mem_gender — varchar(100) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_zipcode — varchar(100) — NOT NULL
- mem_addr — varchar(200) — NOT NULL
- user_ip — varchar(100)
- user_regdate — datetime
- user_modifydate — datetime
- user_grade — varchar(100) — NOT NULL — 1=일반/2=관리자/3=평론가
- policy_a — varchar(100) — NOT NULL
- policy_b — varchar(100) — NOT NULL