2학기 공통_copy

테이블 (15)

alarm_manage

  • alarm_manage_id — int — 기본 키 — NOT NULL — auto_increment
  • user_id — int — NOT NULL
  • alarm_title — varchar(255)
  • alarm_content — varchar(255)
  • alarm_url — varchar(255)
  • register_date — timestamp
  • token — varchar(255)
  • registerDate — timestamp
  • status — bool — 확인하면 비활성화

block_manage

  • block_manage_id — int — 기본 키 — NOT NULL — auto_increment
  • blocked_id — int — NOT NULL — 차단 당한 유저
  • register_date — timestamp

category

  • category_id — int — 기본 키 — NOT NULL — auto_increment
  • category_master_id — int — NOT NULL
  • category_code — varchar(20)
  • category_content — varchar(100)
  • seq — int

category_master

  • category_master_id — int — 기본 키 — NOT NULL — auto_increment
  • category_master_code — varchar(20) — NOT NULL
  • category_master_content — varchar(100)
  • seq — int

follow_manage

  • follow_manage_id — int — 기본 키 — NOT NULL — auto_increment
  • follower_id — int — NOT NULL — 팔로우 신청한 유저
  • following_id — int — NOT NULL — 팔로우를 하는 유저 id
  • register_date — timestamp
  • follow_alarm_setting — bool — 팔로우 중인 사람의 알람을 받을지 여부

image

  • image_id — int — 기본 키 — NOT NULL — auto_increment
  • board_type — varchar(20)
  • board_id — int
  • img_url — varchar(255)
  • origin_filename — varchar(255)
  • temp_filename — varchar(255)
  • register_date — timestamp

live_broadcast

  • live_broadcast_id — int — 기본 키 — NOT NULL — auto_increment
  • seller_id — int — NOT NULL
  • broadcast_title — varchar(255)
  • content — mediumtext
  • script — mediumtext
  • tts_setting — bool — 1,0
  • stt_setting — bool — 1,0
  • chatbot_setting — bool — 1,0
  • share_url — varchar(255)
  • broadcast_start_date — timestamp — 방송 시작일시가 없으면 바로 방송
  • broadcast_end_date — timestamp
  • register_date — timestamp
  • broadcast_status — bool — 1,0
  • view_count — int
  • session_id — int — 방송 시작 이후 session_id 저장해줌
  • topic_id — varchar(255) — kafka랑 연계됨

live_product

  • live_product_id — int — 기본 키 — NOT NULL
  • product_id — int — NOT NULL
  • live_id — int — NOT NULL
  • live_flat_price — int
  • live_rate_price — int
  • live_price_start_date — timestamp
  • live_price_end_date — timestamp
  • main_product_setting — bool
  • register_date — timestamp
  • seq — int

notice_board

  • notice_board_id — int — 기본 키 — NOT NULL — auto_increment
  • writer_id — int — NOT NULL
  • notice_title — varchar(255)
  • notice_content — mediumtext
  • register_date — timestamp

product

  • product_id — int — 기본 키 — NOT NULL — auto_increment
  • category_id — int — NOT NULL
  • seller_id — int — NOT NULL
  • product_name — varchar(255)
  • product_content — mediumtext
  • payment_link — varchar(255)
  • price — int
  • delivery_charge — int
  • quantity — int
  • register_date — timestamp

product_question_board

  • product_question_board_id — int — 기본 키 — NOT NULL — auto_increment
  • writer_id — int — NOT NULL
  • product_id — int — NOT NULL
  • question_content — mediumtext
  • answer_content — mediumtext
  • question_register_date — timestamp
  • answer_register_date — timestamp — 답변 내용이 추가될 때

question_board

  • question_board_id — int — 기본 키 — NOT NULL — auto_increment
  • writer_id — int — NOT NULL
  • question_content — mediumtext
  • answer_content — mediumtext
  • question_register_date — timestamp
  • answer_register_date — timestamp

review_board

  • review_board_id — int — 기본 키 — NOT NULL — auto_increment
  • user_id — int — NOT NULL
  • product_id — int — NOT NULL
  • review_content — mediumtext
  • register_date — timestamp
  • rating — int — 1~5

seller_info

  • seller_info_id — int — 기본 키 — NOT NULL — auto_increment
  • user_id — int — NOT NULL — 사업자의 유저 id
  • business_number — varchar(100)
  • business_content — mediumtext
  • mail_order_sales_number — varchar(100)
  • business_address — varchar(255)
  • phone_number — varchar(20)
  • register_date — timestamp
  • approval_status — bool — 1,0

user

  • user_id — int — 기본 키 — NOT NULL — auto_increment
  • auth — varchar(10) — NOT NULL — buyer(구매자), seller(판매자),admin(관리자)
  • login_id — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL
  • email — varchar(100) — NOT NULL
  • nickname — varchar(50) — NOT NULL
  • sex — char(1) — NOT NULL — F/M
  • birthday — timestamp — NOT NULL
  • profile_img — varchar(255) — 이미지 경로
  • join_date — timestamp — NOT NULL