꽃길만걷개

테이블 (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