semi
Tables (11)
dog_friend_board
- num — INT — Primary key — NOT NULL
- id — VARCHAR(30)
- subject — VARCHAR(100)
- content — VARCHAR(2000)
- writeday — DATETIME
- read_count — INT
dog_profile
- idx — INT — Primary key — NOT NULL
- member_num — INT — Foreign key → member.num
- name — VARCHAR(30)
- gender — VARCHAR(30)
- dog_size — VARCHAR(10)
- birthday — VARCHAR(20)
- photo — VARCHAR(100)
- main_dog — INT
- INDEX — `member_num`
dog_talking_answer
- idx — INT — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- board_num — INT — Foreign key → dog_talking_board.num
- id — VARCHAR(30)
- content — VARCHAR(1000)
- writeday — DATETIME
- INDEX — `board_num`
dog_talking_board
- num — INT — Primary key — NOT NULL
- id — VARCHAR(30)
- photo — VARCHAR(100)
- content — VARCHAR(3000)
- writeday — DATETIME
- readcount — INT
- likes — INT
member
- num — INT — Primary key — NOT NULL
- nickname — VARCHAR(20)
- id — VARCHAR(20)
- password — VARCHAR(20)
- hp — VARCHAR(20)
- addr — VARCHAR(200)
- email — VARCHAR(100)
- create_day — DATETIME
- auth — INT
message
- num — INT — Primary key — NOT NULL
- sender — VARCHAR(50)
- receiver — VARCHAR(50)
- content — VARCHAR(1000)
- writeday — DATETIME
- is_read — INT
notification_board
- num — INT — Primary key — NOT NULL
- title — VARCHAR(50)
- content — VARCHAR(2000)
- writeday — DATETIME
place_share_answer
- idx — INT — Primary key — NOT NULL
- board_num — INT — Foreign key → place_share_board.num
- id — VARCHAR(30)
- content — VARCHAR(1000)
- writeday — DATETIME
- INDEX — `board_num`
place_share_board
- num — INT — Primary key — NOT NULL
- id — VARCHAR(30)
- subject — VARCHAR(50)
- content — VARCHAR(2000)
- photo_name — VARCHAR(100)
- writeday — DATETIME
- read_count — INT
- likes — INT
- place_la — VARCHAR(200)
- place_ma — VARCHAR(200)
- map_addr — VARCHAR(200)
qna_answer
- idx — INT — Primary key — NOT NULL
- board_num — INT — Foreign key → qna_board.num
- admin_id — VARCHAR(100)
- content — VARCHAR(2000)
- writeday — DATETIME
- INDEX — `board_num`
qna_board
- num — INT — Primary key — NOT NULL
- id — VARCHAR(100)
- title — VARCHAR(500)
- content — VARCHAR(2000)
- writeday — DATETIME
- readcount — INT
- secret — INT