cigar 수정12

테이블 (12)

cigar_list

  • cigar_seq — int — NOT NULL
  • cigar_writer_seq — int — NOT NULL
  • cigar_brand — varchar(16) — NOT NULL
  • cigar_name — varchar(30) — NOT NULL
  • cigar_tar — decimal(4,2) — NOT NULL
  • cigar_nicotine — decimal(4,2) — NOT NULL
  • cigar_file_name — varchar(50) — NOT NULL
  • cigar_file_size — int — NOT NULL
  • cigar_hash_tag — varchar(50) — NOT NULL
  • cigar_content — varchar(21000) — NOT NULL
  • cigar_total_grade — decimal(4,2) — NOT NULL
  • cigar_reg_date — datetime — NOT NULL
  • cigar_hit — int — NOT NULL

cigar_map_table

  • map_seq — int
  • lat — decimal(12, 8)
  • lng — decimal(12, 8)
  • smoking_area_title — varchar(20)
  • smoking_area_address — varchar(100)
  • smoking_area_img — varchar(100)

cigar_request

  • request_seq — int — NOT NULL
  • request_writer_seq — int — NOT NULL
  • request_subject — varchar(50)
  • request_writer — varchar(15)
  • request_reg_date — datetime
  • request_content — varchar(21000)
  • request_hit — int
  • request_cmt_count — int
  • request_cigar_brand — varchar(16)
  • request_cigar_name — varchar(30)
  • request_tar — decimal(4,2)
  • request_nicotine — decimal(4,2)
  • request_file_name — varchar(50)
  • request_file_size — int
  • request_smoke_years — date

dislike_check_table

  • dislike_users_seq — int
  • dislike_board_seq — int

free_board

  • free_seq — int — NOT NULL
  • free_writer_seq — int — NOT NULL
  • free_subject — varchar(50) — NOT NULL
  • free_writer — varchar(15) — NOT NULL
  • free_reg_date — datetime — NOT NULL
  • free_content — varchar(21000) — NOT NULL
  • free_hit — int — NOT NULL
  • free_cmt_count — int — NOT NULL
  • free_file_name — varchar(50)
  • free_file_size — int
  • free_smoke_years — date

free_comment

  • free_cmt_seq — int — NOT NULL
  • free_pseq — int — NOT NULL
  • free_cmt_writer_seq — int — NOT NULL
  • free_grp — int — NOT NULL
  • free_grps — int — NOT NULL
  • free_grpl — int — NOT NULL
  • free_cmt_writer — varchar(15) — NOT NULL
  • free_cmt_content — varchar(2000) — NOT NULL
  • free_cmt_reg_date — datetime — NOT NULL

gongji_board

  • gongji_seq — int — NOT NULL
  • gongji_writer_seq — int — NOT NULL
  • gongji_subject — varchar(50) — NOT NULL
  • gongji_writer — varchar(15) — NOT NULL
  • gongji_reg_date — datetime — NOT NULL
  • gongji_content — varchar(21000) — NOT NULL
  • gongji_hit — int — NOT NULL
  • gongji_cmt_count — int — NOT NULL
  • gongji_file_name — varchar(50)
  • gongji_file_size — int
  • gongji_smoke_years — date

gongji_comment

  • gongji_cmt_seq — int — NOT NULL
  • gongji_pseq — int — NOT NULL
  • gongji_cmt_writer_seq — int — NOT NULL
  • gongji_grp — int — NOT NULL
  • gongji_grps — int — NOT NULL
  • gongji_grpl — int — NOT NULL
  • gongji_cmt_writer — varchar(15) — NOT NULL
  • gongji_cmt_content — varchar(2000) — NOT NULL
  • gongji_cmt_reg_date — datetime — NOT NULL

like_check_table

  • like_users_seq — int
  • like_board_seq — int

member_table

  • member_seq — int — NOT NULL
  • email — varchar(50) — NOT NULL
  • password — varchar(65) — NOT NULL
  • name — varchar(15) — NOT NULL
  • phone — varchar(20) — NOT NULL
  • nickname — varchar(15)
  • smoke_years — date
  • sign_date — datetime — NOT NULL
  • birthday — date — NOT NULL

request_comment

  • request_cmt_seq — int — NOT NULL
  • request_pseq — int — NOT NULL
  • request_cmt_writer_seq — int — NOT NULL
  • request_grp — int — NOT NULL
  • request_grps — int — NOT NULL
  • request_grpl — int — NOT NULL
  • request_cmt_writer — varchar(15) — NOT NULL
  • request_cmt_content — varchar(2000) — NOT NULL
  • request_cmt_reg_date — datetime — NOT NULL

review_board

  • review_seq — int — NOT NULL
  • review_writer_seq — int — NOT NULL
  • review_cigar_seq — int — NOT NULL
  • review_subject — varchar(50) — NOT NULL
  • review_writer — varchar(15) — NOT NULL
  • review_reg_date — datetime — NOT NULL
  • review_content — varchar(21000) — NOT NULL
  • review_hit — int — NOT NULL
  • review_cmt_count — int — NOT NULL
  • review_grade — int — NOT NULL
  • review_like — int — NOT NULL
  • review_dislike — int — NOT NULL
  • review_smoke_years — date