꽃길만걷개
테이블 (8)
BOARD
- board_num — number — 기본 키
- user_id (user_id2) — VARCHAR2(50) — 외래 키 → MEMBERS.user_id
- board_content — VARCHAR2(4000) — NOT NULL
- board_tatle — VARCHAR2(100) — NOT NULL
- board_date — DATE
- board_code — VARCHAR2(5)
COMENT
- coment_num — number — 기본 키
- board_num (board_num2) — number — 외래 키 → BOARD.board_num
- coment_writer — VARCHAR2(50) — NOT NULL
- conment_date — DATE
DAIRY
- dairy — NUMBER — 기본 키
- dairy_content — VARCHAR2(20) — NOT NULL
- cal_tatle — VARCHAR2(20) — NOT NULL
- cal_startStr — VARCHAR2(30) — NOT NULL
- cal_endStr — VARCHAR2(30) — NOT NULL
- dairy_picture — VARCHAR2(100)
- cal_adress — VARCHAR2(100)
- Y_N — VARCHAR2(5) — NOT NULL
FACILITY
- num — number — 기본 키
- name — VARCHAR2(50) — NOT NULL
- tel — VARCHAR2(20)
- adress — VARCHAR2(100) — NOT NULL
- select_code — VARCHAR2(4) — NOT NULL
MEMBERS
- user_id — VARCHAR2(50) — 기본 키
- user_pw — VARCHAR2(20) — NOT NULL
- user_nickname — VARCHAR2(20) — NOT NULL
- main_adress — VARCHAR2(100) — NOT NULL
- sub_adress — VARCHAR2(100)
- user_email — VARCHAR2(50)
- user_tel — VARCHAR2(20)
- user_gender — VARCHAR2(5)
- user_picture — VARCHAR2(50)
- user_date — DATE
MEMBER_SNS
- email — VARCHAR2(50) — 기본 키
- sns_code — VARCHAR2(4)
- picture — VARCHAR2(50)
- gender — VARCHAR2(4) — NOT NULL
- random_id — VARCHAR2(50) — NOT NULL
PET
- pet_id — VARCHAR2(50) — 기본 키
- user_id (user_id2) — VARCHAR2(50) — 외래 키 → MEMBERS.user_id
- pet_type — VARCHAR2(5)
- pet_picture — VARCHAR2(100)
- pet_age — NUMBER
- pet_name — VARCHAR2(20)
PET_HISTORY
- history_num — NUMBER — 기본 키
- pet_id (pet_id2) — VARCHAR2(50) — 외래 키 → PET.pet_id
- history_date — DATE — NOT NULL
- history_content — VARCHAR2(100) — NOT NULL