FORET

Tables (16)

board

  • id — INT(11) — Primary key — NOT NULL
  • writer_id — INT(11) — Foreign key → member.id — NOT NULL
  • foret_id — INT(11) — Foreign key → foret.id — NOT NULL
  • type — INT(11) — 0 : 공지사항 1 : 포레 공지사항 2 : 포레 일정 게시판 3 : 포레 게시판 4 : 익명 게시판
  • hit — INT(11)
  • subject — VARCHAR(100)
  • content — TEXT
  • reg_date — DATETIME
  • edit_date — DATETIME

board_comment

  • id — INT(11) — Primary key — NOT NULL
  • board_id — INT(11) — Foreign key → board.id — NOT NULL
  • writer_id — INT(11) — Foreign key → member.id — NOT NULL
  • group_no — INT(11)
  • content — VARCHAR(200)
  • reg_date — DATETIME

board_photo

  • id — INT(11) — Primary key — NOT NULL
  • board_id — INT(11) — Foreign key → board.id — NOT NULL
  • dir — VARCHAR(200)
  • filename — VARCHAR(200)
  • originname — VARCHAR(200)
  • filesize — INT(11)
  • filetype — VARCHAR(200)
  • reg_date — DATETIME

foret

  • id — INT(11) — Primary key — NOT NULL
  • leader_id — INT(11) — Foreign key → member.id — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • introduce — VARCHAR(600) — NOT NULL — 600바이트 200자
  • max_member — INT(11) — NOT NULL
  • reg_date — DATETIME — NOT NULL

foret_photo

  • id — INT(11) — Primary key — NOT NULL
  • foret_id — INT(11) — Foreign key → foret.id — NOT NULL
  • dir — VARCHAR(200)
  • filename — VARCHAR(200)
  • originname — VARCHAR(200)
  • filesize — INT(11)
  • filetype — VARCHAR(200)
  • reg_date — DATETIME

foret_region

  • foret_id — INT(11) — Foreign key → foret.id — NOT NULL
  • region_si (Field2) — VARCHAR(30)
  • region_gu (Field) — VARCHAR(30)

foret_tag

  • foret_id — INT(11) — Foreign key → foret.id — NOT NULL
  • tag_name (Field) — VARCHAR(30)
  • Field2

like_board

  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • board_id — INT(11) — Foreign key → board.id — NOT NULL

like_comment

  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • comment_id — INT(11) — Foreign key → board_comment.id — NOT NULL

member

  • id — INT(11) — Primary key — NOT NULL
  • name — VARCHAR(30) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • birth — DATE — NOT NULL
  • reg_date — DATETIME — NOT NULL

member_foret

  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • foret_id — INT(11) — Foreign key → foret.id — NOT NULL

member_photo

  • id — INT(11) — Primary key — NOT NULL
  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • dir — VARCHAR(200)
  • filename — VARCHAR(200) — 실제 사용 이름
  • originname — VARCHAR(200)
  • filesize — INT(11)
  • filetype — VARCHAR(200)
  • reg_date — DATETIME

member_region

  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • region_su (Field2) — VARCHAR(30)
  • region_gu (Field) — VARCHAR(30)

member_tag

  • member_id — INT(11) — Foreign key → member.id — NOT NULL
  • tag_name (Field) — VARCHAR(30)

region

  • region_id — INT(11) — Primary key — NOT NULL
  • region_si — VARCHAR(30) — NOT NULL
  • region_gu — VARCHAR(30) — NOT NULL

tag

  • tag_id — INT(11) — Primary key — NOT NULL
  • tag_name — VARCHAR(30) — NOT NULL