Shopping

Tables (8)

TB_BOARD (자유게시판)

  • board_idx (게시글번호) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(256)
  • content (내용) — text
  • reg_dt (작성일자) — varchar(16)
  • mod_dt (수정일자) — varchar(16)
  • board_type (글분류) — varchar(1)
  • reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL

TB_BOARD_FILE (자유게시판첨부파일)

  • board_file_idx (첨부파일번호) — bigint — Primary key — NOT NULL
  • file_name (파일명) — varchar(128)
  • file_path (저장경로) — varchar(256)
  • reg_idx (작성자) — bigint
  • reg_dt (작성일자) — varchar(16)
  • board_idx (게시글번호) — bigint — Foreign key → TB_BOARD.board_idx — NOT NULL

TB_COMMENT (자유게시판댓글)

  • comment_idx (댓글번호) — bigint — Primary key — NOT NULL
  • content (내용) — text
  • reg_dt (작성일자) — varchar(16)
  • mod_dt (수정일자) — varchar(16)
  • board_idx (게시글번호) — bigint — Foreign key → TB_BOARD.board_idx — NOT NULL
  • reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL

TB_REG_ITEMS (판매물건)

  • reg_item_idx (판매등록물건번호) — bigint — Primary key — NOT NULL
  • item_name (물건명) — varchar(16)
  • item_count (수량) — int
  • item_price (판매가) — int
  • item_info (판매정보) — text
  • item_type (물건분류) — int
  • reg_dt (작성일자) — varchar(16)
  • reg_idx (작성자) — bigint — Foreign key → TB_USER.user_idx — NOT NULL
  • avg_score (평균평점) — float

TB_REG_ITEM_ANSWER (답변)

  • reg_item_ans_idx (답변번호) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(256)
  • content (내용) — text
  • reg_idx (작성자) — bigint
  • reg_dt (작성일자) — varchar(16)
  • reg_item_ques_idx (질문번호) — bigint — Foreign key → TB_REG_ITEM_QUESTION.reg_item_ques_idx — NOT NULL

TB_REG_ITEM_QUESTION (질문)

  • reg_item_ques_idx (질문번호) — bigint — Primary key — NOT NULL
  • title (제목) — varchar(256)
  • content (내용) — text
  • reg_idx (작성자) — bigint
  • reg_dt (작성일자) — varchar(16)
  • reg_item_idx (판매등록물건번호) — bigint — Foreign key → TB_REG_ITEMS.reg_item_idx — NOT NULL

TB_REG_ITMES_BUY_NOTE (구매후기)

  • reg_buy_note_idx (구매후기번호) — bigint — Primary key — NOT NULL
  • reg_idx (작성자) — bigint
  • reg_dt (작성일자) — varchar(16)
  • mod_dt (수정일자) — varchar(16)
  • title (제목) — varchar(256)
  • content (내용) — text
  • score (평점) — float
  • reg_item_idx (판매등록물건번호) — bigint — Foreign key → TB_REG_ITEMS.reg_item_idx — NOT NULL

TB_USER (회원)

  • user_idx (회원번호) — bigint — Primary key — NOT NULL
  • user_id (아이디(이메일)) — varchar(16)
  • password (비밀번호) — varchar(128)
  • name (이름) — varchar(16)
  • phone (전화번호) — varchar(16)
  • email_yn (이메일수신동의여부) — varchar(1)
  • si_do (주소1(시도)) — varchar(16)
  • si_gun_gu (주소2(시군구)) — varchar(16)
  • eup_myeon_dong (주소3(읍면동)) — varchar(16)
  • addr_detail (주소4(상세주소)) — varchar(32)
  • authority (권한) — varchar(16)