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