carpool

Tables (4)

car_board

  • board_no (Key) — Primary key — NOT NULL
  • board_status (Field2)
  • member_id (Field3)
  • board_title (Field4)
  • board_contents (Field5)
  • board_startpoint (Field6)
  • board_endpoint (Field7)
  • board_starttime (Field8)
  • board_viewcount (Field9)

car_info (Untitled2)

  • board_no (Key) — NUMBER(10) — Foreign key → car_board.board_no — NOT NULL
  • car_type (Field2)
  • maxseat (Field)
  • car_year (Field3)

comment (Untitled)

  • Key (member_no) — Foreign key → member.Key — NOT NULL
  • board_no (Key) — Foreign key → car_board.board_no — NOT NULL
  • comment_no (Field) — NUMBER
  • board_no (Field2) — NUMBER
  • parent_no (Field3) — NUMBER
  • member_id (Field4) — VARCHAR2(255)
  • comment_content (Field5) — VARCHAR2(255)
  • comment_regdt (Field6) — DATE
  • comment_depth (Field7) — NUMBER

member

  • Key (member_no) — Primary key — NOT NULL
  • Field (member_birth)
  • Field2 (member_email)
  • Field3 (member_id)
  • Field4 (member_password)
  • Field5 (member_license)
  • Field6 (member_mobile)
  • Field7 (member_name)