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