ERD_final

Tables (5)

board_table (Untitled)

  • BOARD_NO (Key) — NUMBER — Primary key — NOT NULL
  • MEMBER_ID (Field2) — VARCHAR2(30)
  • BOARD_STATUS (Field3) — NUMBER(1,0)
  • BOARD_TITLE (Field4) — VARCHAR2(60)
  • BOARD_STARTPOINT (Field5) — VARCHAR2(30)
  • BOARD_ENDPONT (Field6) — VARCHAR2(30)
  • BOARD_STARTTIME (Field7) — TIMESTAMP(6)
  • BOARD_CONTENTS (Field8) — VARCHAR2(500)

car_info_table (Untitled2)

  • BOARD_NO (Key) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
  • CAR_TYPE (Field2) — VARCHAR2(50)
  • MAXSEAT (Field3) — NUMBER(10,0)
  • CAR_YEAR (Field4) — MEMBER(10,0)

comment_table (Untitled5)

  • COMMENT_NO (Key3) — NUMBER — Primary key — NOT NULL
  • BOARD_NO (Key) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
  • MEMBER_ID (Key2) — NUMBER — Foreign key → member_table.MEMBER_NO — NOT NULL
  • PARENT_NO (Field3) — NUMBER
  • COMMENT_CONTENT (Field5) — VARCHAR2(255)
  • COMMENT_REGDT (Field6) — DATE
  • COMMENT_DEPTH (Field7) — NUMBER

member_table (Untitled3)

  • MEMBER_NO (Key) — NUMBER — Primary key — NOT NULL
  • MEMBER_ID (Field) — VARCHAR2(255)
  • MEMBER_BIRTH (Field2) — VARCHAR2(20)
  • MEMBER_EMAIL (Field3) — VARCHAR2(50)
  • MEMBER_LICENSE (Field4) — VARCHAR2(30)
  • MEMBER_LIKE (Field5) — NUMBER(10,0)
  • MEMBER_MOBILE (Field6) — VARCHAR2(30)
  • MEMBER_NAME (Field7) — VARCHAR2(20)
  • MEMBER_PASSWORD (Field8) — VARCHAR2(255)

passenger_table (Untitled4)

  • PASSENGER_TABLE_NO (Key3) — NUMBER — Primary key — NOT NULL
  • BOARD_NO (Key2) — NUMBER — Foreign key → board_table.BOARD_NO — NOT NULL
  • MEMBER_ID (Key) — NUMBER — Foreign key → member_table.MEMBER_NO — NOT NULL
  • PASSENGER_CHECK (Field4) — VARCHAR2(10)