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