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