cigar
Tables (10)
Cigar List (cigar_list)
- Key (cigar_seq) — int — Primary key — NOT NULL
- Cigar Writer Seq (cigar_writer_seq) — int — Foreign key → Member Table.Key — NOT NULL
- Cigar Brand (cigar_brand) — varchar(16) — NOT NULL
- Cigar Name (cigar_name) — varchar(30) — NOT NULL
- Cigar Tar (cigar_tar) — decimal(4, 2) — NOT NULL
- Cigar Nicotine (cigar_nicotine) — decimal(4, 2) — NOT NULL
- Cigar File Name (cigar_file_name) — varchar(30) — NOT NULL
- Cigar File Size (cigar_file_size) — int — NOT NULL
- Cigar Hash Tag (cigar_hash_tag) — varchar(50) — NOT NULL
- Cigar Content (cigar_content) — varchar(21000) — NOT NULL
- Cigar Total Grade (cigar_total_grade) — varchar(8) — NOT NULL
Cigar Requset (cigar_requset)
- Key (requset_seq) — int — Primary key — NOT NULL
- Requset Writer Seq (requset_writer_seq) — int — Foreign key → Member Table.Key — NOT NULL
- Requset Subject (requset_subject) — varchar(50)
- Requset Writer (requset_writer) — varchar(15)
- Request Reg Date (request_reg_date) — datetime
- Requset Content (requset_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)
- Requset File Name (requset_file_name) — varchar(30)
- Requset File Size (requset_file_size) — int
- Requset Smoke Years (requset_smoke_years) — date
Free Board (free_board)
- Key (free_seq) — int — Primary key — NOT NULL
- Free Writer Seq (free_writer_seq) — int — Foreign key → Member Table.Key — NOT NULL
- Free Subject (free_subject) — varchar(50) — NOT NULL
- Free Writer (free_writer) — int — NOT NULL
- Free Reg Date (free_reg_date) — datetime — NOT NULL
- Free Content (free_content) — varchar(21000) — NOT NULL
- Free Hit (free_hit) — int — NOT NULL
- Free Cmt Count (free_cmt_count) — int — NOT NULL
- Free File Name (free_file_name) — varchar(30)
- Free File Size (free_file_size) — int
- Free Smoke Years (free_smoke_years) — date
Free Comment (Free_comment)
- Key (free_cmt_seq) — int — Primary key — NOT NULL
- free_pseq — int — Foreign key → Free Board.Key — NOT NULL
- free_cmt_writer_seq — int — Foreign key → Free Board.Free Writer Seq — NOT NULL
- Free Grp (free_grp) — int — NOT NULL
- Free Grps (free_grps) — int — NOT NULL
- Free Grpl (free_grpl) — int — NOT NULL
- Free Cmt Writer (free_cmt_writer) — varchar(15) — NOT NULL
- Free Cmt Content (free_cmt_content) — varchar(2000) — NOT NULL
- Free Cmt Reg Date (free_cmt_reg_date) — date — NOT NULL
Gongji Board (gongji_board)
- Key (gongji_seq) — int — Primary key — NOT NULL
- Gongji Writer Seq (gongji_writer_seq) — int — Foreign key → Member Table.Key — NOT NULL
- gongji_subject — varchar(50) — NOT NULL
- gongji_writer — varchar(15) — NOT NULL
- gongji_reg_date — date — NOT NULL
- gongji_content — varchar(21000) — NOT NULL
- gongji_hit — int — NOT NULL
- goingji_cmt_count — int — NOT NULL
- gongji_file_name — varchar(30)
- gongji_file_size — int
- goingji_smoke_years — date
Gongji Comment (gongji_comment)
- Key (gongji _cmt_seq) — int — Primary key — NOT NULL
- gongji_pseq — int — Foreign key → Gongji Board.Key — NOT NULL
- gongji_cmt_writer_seq — int — Foreign key → Gongji Board.Gongji Writer Seq — 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 — date — NOT NULL
Member Table (member_table)
- Key (member_seq) — int — Primary key — NOT NULL
- ID (id) — varchar(15) — NOT NULL
- Password (password) — varchar(65) — NOT NULL
- Email (email) — varchar(50) — NOT NULL
- Name (name) — varchar(15) — NOT NULL
- Address (address) — varchar(50) — NOT NULL
- NickName (nickname) — varchar(15)
- Smoke Years (smoke_years) — date
- Prefer Cigar (prefer_cigar) — varchar(30)
- Sign_Date (sign_date) — datetime — NOT NULL
- BirthDay (birthday) — date — NOT NULL
Request Comment (request_comment)
- Key (request_cmt_seq) — int — Primary key — NOT NULL
- request_pseq — int — Foreign key → Cigar Requset.Key — NOT NULL
- request_cmt_writer_seq — int — Foreign key → Cigar Requset.Requset Writer Seq — NOT NULL
- Request Grp (request_grp) — int — NOT NULL
- Request Grps (request_grps) — int — NOT NULL
- Request Grpl (request_grpl) — int — NOT NULL
- Request Cmt Writer (request_cmt_writer) — varchar(15) — NOT NULL
- Request Cmt Content (request_cmt_content) — varchar(2000) — NOT NULL
- Request Cmt Reg Date (request_cmt_reg_date) — date — NOT NULL
Review Board (review_board)
- Key (review_seq) — int — Primary key — NOT NULL
- Review Writer Seq (review_writer_seq) — int — Foreign key → Member Table.Key — NOT NULL
- Review Cigar Seq (review_cigar_seq) — int — Foreign key → Cigar List.Key — NOT NULL
- Review Subject (review_subject) — varchar(50) — NOT NULL
- Review Wrtier (review_wrtier) — varchar(15) — NOT NULL
- Review Reg Date (review_reg_date) — date — NOT NULL
- Review Content (review_content) — varchar(21000) — NOT NULL
- Review Hit (review_hit) — int — NOT NULL
- Review Cmt Count (review_cmt_count) — int — NOT NULL
- Review Grade (review_grade) — int — NOT NULL
- Review Like (review_like) — int — NOT NULL
- Review Dislike (review_dislike) — int — NOT NULL
- Review File Name (review_file_name) — varchar(30)
- Review File Size (review_file_size) — int
- Review Smoke Years (review_smoke_years) — date
Review Comment (review_comment)
- Key (review _cmt_seq) — int — Primary key — NOT NULL
- Review Pseq (review_pseq) — int — Foreign key → Review Board.Key — NOT NULL
- Review Cmt Writer Seq (review_cmt_writer_seq) — int — Foreign key → Review Board.Review Writer Seq — NOT NULL
- Review Grp (review_grp) — int — NOT NULL
- Review Grps (review_grps) — int — NOT NULL
- Review Grpl (review_grpl) — int — NOT NULL
- Review Cmt Writer (review_cmt_writer) — varchar(15) — NOT NULL
- Review Cmt Content (review_cmt_content) — varchar(2000) — NOT NULL
- Review Cmt Reg Date (review_cmt_reg_date) — date — NOT NULL