final_erd

Tables (4)

CAR_BOARD (Untitled)

  • BOARD_NO (Key) — NUMBER — Primary key — NOT NULL
  • MEMBER_NO (Key2) — NUMBER — Foreign key → MEMBER_TABLE.MEMBER_NO — NOT NULL
  • MEMBER_ID (Field) — VARCHAR2(30)
  • BOARD_STATUS (Field2) — NUMBER(1,0)
  • BOARD_TITLE (Field3) — VARCHAR2(60)
  • BOARD_STARTPOINT (Field4) — VARCHAR2(30)
  • BOARD_ENDPOINT (Field5) — VARCHAR2(30)
  • BOARD_STARTTIME (Field6) — TIMESTAMP(6)
  • BOARD_CONTENTS (Field7) — VARCHAR2(500)

CAR_INFO (Untitled2)

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

MEMBER_TABLE (Untitled3)

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

PASSENGER_TABLE (Untitled4)

  • BOARD_NO (Key) — Foreign key → CAR_BOARD.BOARD_NO — NOT NULL
  • MEMBER_NO (Key2) — NUMBER — Foreign key → CAR_BOARD.MEMBER_NO — NOT NULL
  • PASSENGER_ID (Field2) — VARCHAR2(255)
  • PASSENGER_TABLE_NO (Field) — NUMBER
  • PASSENGER_CHECK (Field4) — VARCHAR2(10)