forTRIP

Tables (3)

ACCOUNTBOOK (Untitled2)

  • ID — VARCHAR2(20) — Primary key — NOT NULL
  • TOTAL_AMOUNT — NUMBER
  • SPENDING_TYPE — VARCHAR2(50)
  • SPENDING_AMOUNT — NUMBER
  • LOCATION — VARCHAR2(20)

RECOMMAND_PLACE (Untitled)

  • NAME — VARCHAR2(50) — Primary key — NOT NULL
  • THUMNAIL — ???이미지??
  • URL — ????주소 엄청긴데
  • EXPLANATION — VARCHAR2(100)

SCHEDULE (Untitled3)

  • ID — VARCHAR2(20) — Primary key — NOT NULL
  • SCHE_NAME — VARCHAR2(20)
  • S_DATE — DATE — NOT NULL — 시작일
  • F_DATE — DATE
  • PLACE_NAME — VARCHAR2(20)
  • 소요시간 — 이해못함이게뭔지
  • CREW_MEMBER — VARCHAR2(10)