JPAShop_ToyProject
Tables (12)
Untitled
- Field
tb_admin (관리자 테이블)
- ADMIN_KEY (KEY) — bigint — Primary key — NOT NULL
- ADMIN_ID (Field) — VARCHAR(30)
- ADMIN_PW (Field2) — VARCHAR(200)
- ADMIN_NICNAME (Field3) — VARCHAR(50)
- ADMIN_NM (Field4) — VARCHAR(30)
- ADMIN_CK (Filed5) — CHAR(1)
tb_board (문의 및 후기 테이블)
- BOARD_KEY (KEY) — bigint — Primary key — NOT NULL
- USER_KEY (KEY2) — bigint — Foreign key → tb_member.USER_KEY — NOT NULL
- COM_KEY (KEY3) — bigint — Foreign key → tb_comments.COM_KEY — NOT NULL
- BD_TYPE (Field) — CHER(1)
- BD_TITLE (Field2) — VARCHAR(200)
- BD_WRITER (Field3) — VARCHAR(30)
- BD_IMG (Field4) — VARCHAR(500)
- BD_HIT (Field5) — NUMBER
- NT_CONTENT (Field6) — VARCHAR(2000)
- RATE (Field7) — int
- CREATE_DATE (Field8) — DATE
- UPDATE_DATE (Field9) — Date
tb_cate (장바구니 테이블)
- CATE_KEY (Key) — bigint — Primary key — NOT NULL
- USER_KEY (KEY) — bigint — Foreign key → tb_member.USER_KEY — NOT NULL
- PRO_KEY (Key2) — bigint — Foreign key → tb_product.PRO_KEY — NOT NULL
- SESSION_ID (Field) — VARCHAR(200)
- CATE_CNT (Field2) — NUMBER
- CREATE_DATE (Field3) — DATE
- UPDATE_DATE (Field4) — Date
tb_category (카테고리 테이블)
- CG_KEY (Key) — bigint — Primary key — NOT NULL
- CG_REF (Key2) — bigint — Foreign key → tb_category.CG_KEY — NOT NULL
- CG_NM (Field) — VARCHAR(30)
- LEVEL (Field2) — tinyint
- CREATE_DATE (Field3) — DATE
- UPDATE_DATE (Field4) — DATE
tb_comments (댓글 테이블)
- COM_KEY (KEY) — bigint — Primary key — NOT NULL
- COM_WRITER (Field) — VARCHAR(30)
- COM_CONTENT (Field2) — VARCHAR(2000)
- CREATE_DATE (Field3) — DATE
- UPDATE_DATE (Field4) — Date
tb_like (찜 목록 테이블)
- USER_KEY (KEY) — bigint — Foreign key → tb_member.USER_KEY — NOT NULL
- PRO_KEY (Key) — bigint — Foreign key → tb_product.PRO_KEY — NOT NULL
- CREATE_DATE (Field) — DATE
- UPDATE_DATE (Field2) — Date
tb_member (회원 테이블)
- USER_KEY (KEY) — bigint — Primary key — NOT NULL
- ADMIN_KEY (KEY2) — bigint — Foreign key → tb_admin.ADMIN_KEY — NOT NULL
- USER_ID (Field) — VARCHAR(30)
- USER_PW (Field2) — VARCHAR(200)
- USER_NM (Field3) — VARCHAR(30)
- USER_NICKNAME (Field4) — VARCHAR(50)
- USER_BIRTH (Field5) — VARCHAR(30)
- USER_PHONE (Field6) — VARCHAR(10)
- USER_CK (Field7) — CHAR(1)
- ZIPCODE (Field8) — int(6)
- ADDRESS_BASIC (Field9) — VARCHAR(100)
- ADDRESS_DETAIL (Field10) — VARCHAR(100)
- CREATE_DATE (Field11) — DATE
- UPDATE_DATE (Field12) — DATE
tb_notice (공지사항 테이블)
- NT_KEY (KEY) — bigint — Primary key — NOT NULL
- ADMIN_KEY (KEY2) — bigint — Foreign key → tb_admin.ADMIN_KEY — NOT NULL
- COM_KEY (KEY3) — bigint — Foreign key → tb_comments.COM_KEY — NOT NULL
- NT_TITLE (Field) — VARCHAR(200)
- NT_WRITER (Field2) — VARCHAR(30)
- NT_IMG (Field3) — VARCHAR(500)
- NT_HIT (Field4) — int
- NT_CONTENT (Field5) — VARCHAR(2000)
- CREATE_DATE (Field6) — DATE
- UPDATE_DATE (Field7) — Date
tb_order (주문 테이블)
- ORDER_KEY (Key) — bigint — Primary key — NOT NULL
- USER_KEY (KEY) — bigint — Foreign key → tb_member.USER_KEY — NOT NULL
- STATUS_CD (Field) — char(2)
- PAID_YN (Field2) — char(1)
- PAY_METHOD_CD (Field3) — char(2)
- PRICE (Field4) — bigint
- DELIVERY_FEE (Field5) — bigint
- TOTAL_PRICE (Field6) — bigint
- ZIPCODE (Field7) — int(6)
- ADDRESS (Field8) — VARCHAR(100)
- NOTES (Field9) — VARCHAR(100)
- DELIVERY_START_DT (Field10) — DATE
- DELIVERY_END_DT (Field11) — DATE
- CANCEL_YN (Field12) — char(1)
- CANCEL_DT (Field13) — DATE
- CANCEL_DESC (Field14) — VARCHAR(200)
- REFOUND_YN (Field15) — char(1)
- REFOUND_DT (Field16) — DATE
- REFOUND_REJECT_YN (Field17) — char(1)
- REFOUND_REJECT_DT (Field18) — DATE
- REFOUND_REJECT_DESC (Field19) — VARCHAR(200)
- CREATE_DATE (Field20) — DATE
- UPDATE_DATE (Field21) — DATE
tb_order_product (주문 상품 테이블)
- ORDER_PRO_KEY (Key) — bigint — Primary key — NOT NULL
- ORDER_KEY (Key2) — bigint — Foreign key → tb_order.ORDER_KEY — NOT NULL
- PRO_KEY (Key3) — bigint — Foreign key → tb_product.PRO_KEY — NOT NULL
- ORDER_CNT (Field) — int
- ORDER_PRICE (Field2) — bigint
- CREATE_DATE (Field3) — DATE
- UPDATE_DATE (Field4) — Date
tb_product (상품 테이블)
- PRO_KEY (Key) — bigint — Primary key — NOT NULL
- USER_KEY (KEY) — bigint — Foreign key → tb_member.USER_KEY — NOT NULL
- CG_KEY (Key2) — bigint — Foreign key → tb_category.CG_KEY — NOT NULL
- PRO_NM (Field) — VARCHAR(30)
- PRO_PRICE (Field2) — VARCHAR(30)
- PRO_CONTENT (Field3) — VARCHAR(1000)
- PRO_YN (Field4) — CHAR(1)
- PRO_CNT (Field5) — NUMBER(30)
- PRO_QTY (Field6) — NUMBER(30)
- PRO_SIZE (Field7) — VARCHAR(30)
- PRO_COLOR (Field8) — VARCHAR(30)
- PRO_IMG1 (Field9) — VARCHAR(500)
- PRO_IMG2 (Field10) — VARCHAR(500)
- PRO_IMG3 (Field11) — VARCHAR(500)
- PRO_IMG4 (Field12) — VARCHAR(500)
- PRO_IMG5 (Field13) — VARCHAR(500)
- PRO_DELETED (Field14) — CHAR(1)
- CREATE_DATE (Field15) — DATE
- UPDATE_DATE (Field16) — DATE