PJT1
Tables (15)
board
- board_id — unsigned int — Primary key
- user_id — unsigned int — Foreign key → user.user_id — NOT NULL
- dog_id — unsigned int — Foreign key → dog.dog_id — NOT NULL
- image — char(36) — NOT NULL
- content — varchar(280)
chatroom
- chatroom_id — unsigned int — Primary key — NOT NULL
chatting
- chatting_id — unsigned int — Primary key — NOT NULL
- chatting_user_id — unsigned int — Foreign key → user.user_id
- chatting_room_id — unsigned int — Foreign key → chatroom.chatroom_id — NOT NULL
- chatting_content — varchar(100)
- chatting_date — date
- chatting_idx — unsigned int
chatuser
- chatuser_id — unsigned int — Primary key — NOT NULL
- chatuser_other_id — unsigned int — Foreign key → user.user_id
- chatuser_user_id — unsigned int — Foreign key → user.user_id
- chat_room_id — unsigned int — Foreign key → chatroom.chatroom_id — NOT NULL
- activation — int
- start_chat_num — unsigned int
- last_chat_num — unsigned int
- lasttest_chat — unsigned int
comment
- comment_id — unsigned int — Primary key
- user_id — unsigned int — Foreign key → user.user_id — NOT NULL
- board_id — unsigned int — Foreign key → board.board_id
- comment_content — varchar(100) — NOT NULL
dog
- dog_id — unsigned int — Primary key
- user_id — unsigned int — Foreign key → user.user_id
- dog_name — varchar(10) — NOT NULL
- dog_gender — char(1) — NOT NULL
- dog_type — varchar(50) — NOT NULL
- dog_birth — char(6) — NOT NULL
- dog_weight — varchar(4) — NOT NULL
- dog_neutered — boolean — NOT NULL
- dog_character1 — char(1) — NOT NULL — i : independent d : dependent
- dog_character2 — char(1) — NOT NULL — a : active i : inactive
- dog_image — varchar(100)
- description — varchar(40) — NOT NULL
facility
- facility_id — unsigned int — Primary key — NOT NULL
- facility_name — varchar(100)
- facility_address — varchar(100)
- type — varchar(12)
- longitude — varchar(11)
- latitude — varchar(11)
- closed_days — varchar(100)
- opening_hours — varchar(100)
- phone — char(13)
follow
- follow_id — unsigned int — Primary key
- follow_user_id — int(unsigned) — Foreign key → user.user_id — NOT NULL
- followed_dog_id — int(unsigned) — Foreign key → dog.dog_id — NOT NULL
like
- like_id — unsigned int — Primary key
- user_id — unsigned int — Foreign key → user.user_id — NOT NULL
- board_id — unsigned int — Foreign key → board.board_id
notify
- notify_id — unsigned int — Primary key
- receiver_user_id — unsigned int — Foreign key → user.user_id
- sender_user_id — unsigned int — Foreign key → user.user_id
- notify_type (type) — char(1) — NOT NULL — follow : 'f' like : 'l' cancel : 'c'
- dog_id — unsigned int
- board_id — unsigned int — type : f -> sender : userid type: l -> sender : feedid
- notify_date — date — NOT NULL — notify date for sorting
- check — boolean — whether one checked
received_request_dog
- received_id — unsigned int — Primary key — NOT NULL
- room_id — unsigned int — Foreign key → request.room_id — NOT NULL
- dog_id — unsigned int — Foreign key → dog.dog_id
request
- room_id — unsigned int — Primary key — NOT NULL
- sent_user_id — unsigned int — Foreign key → user.user_id
- received_user_id — unsigned int — Foreign key → user.user_id
- place — varchar(40)
- date_time — date
- status — char(1) — NOT NULL — a: accepted n : not confirmed c : canceled
- is_sender_rate — boolean
- is_receiver_rate — boolean — false
sent_request_dog
- sent_id — unsigned int — Primary key — NOT NULL
- room_id — unsigned int — Foreign key → request.room_id — NOT NULL
- dog_id — unsigned int — Foreign key → dog.dog_id
user
- user_id — unsigned int — Primary key
- email — varchar(50) — NOT NULL
- nickname — varchar(16)
- password — char(64) — NOT NULL
- user_birth — char(4)
- user_gender — char(1) — NOT NULL
- address — varchar(100)
- region_code — char(5)
- social — char(1) — naver : 'n' kakao : 'k' google : 'g' origin : 'o'
- rating_sum — unsigned int
- rating_count — unsigned int
- role_type — varchar(5)
wait_user
- user_id — unsigned int — Primary key
- email — varchar(50) — NOT NULL
- nickname — varchar(16)
- password — char(64) — NOT NULL
- user_birth — char(4)
- user_gender — char(1) — NOT NULL
- address — varchar(100)
- region_code — char(5)
- regist_date — date — NOT NULL