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