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)