test

Tables (19)

CopyOfUntitled2

  • post_number — number — Primary key — NOT NULL
  • title — varchar2(100) — NOT NULL
  • post_date — date — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL
  • latitude — number — NOT NULL
  • longitude — number — NOT NULL
  • address — varchar2(100) — NOT NULL

CopyOfUntitled3

  • commet_number — number — Primary key — NOT NULL
  • content — varchar2(500) — NOT NULL
  • writer — varchar2(100) — NOT NULL
  • post_number — number — Foreign key → CopyOfUntitled2.post_number — NOT NULL

Untitled

  • ticket_code — varchar2(100) — Primary key — NOT NULL
  • ticket_name — varchar2(100) — NOT NULL
  • timeLimit — number — NOT NULL
  • dateLimit — number — NOT NULL

Untitled10

  • file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
  • report_Id — number — Foreign key → Untitled6.report_Id — NOT NULL

Untitled11

  • present — id` — Primary key — NOT NULL
  • give — member — NOT NULL
  • take — member — NOT NULL
  • ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
  • send — date` — NOT NULL

Untitled13

  • delay_num — number — Primary key — NOT NULL
  • ill — varchar2 — Foreign key → Untitled14.ill — NOT NULL
  • delay_time — number
  • delay_money — number
  • purchase_YN — VARCHAR(255)
  • Key — VARCHAR(255) — Foreign key → Untitled4.Key — NOT NULL

Untitled14

  • ill — varchar2 — Primary key — NOT NULL
  • active — varchar2(102341205)
  • active-time — date
  • ps — expire
  • ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL

Untitled2

  • post_num — number — Primary key — NOT NULL
  • title — varchar2(100) — NOT NULL
  • post_date — date — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL
  • category — varchar2(100) — NOT NULL

Untitled3

  • commet_number — number — Primary key — NOT NULL
  • content — varchar2(500) — NOT NULL
  • writer — varchar2(100) — NOT NULL
  • post_number — number — Foreign key → Untitled2.post_num — NOT NULL

Untitled4

  • Key — VARCHAR(255) — Primary key — NOT NULL
  • rental — start
  • return_date — date
  • used-time — number
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL
  • bike_serial_number — number — Foreign key → bike.bike_serial_number — NOT NULL

Untitled5

  • purchase_num — number — Primary key — NOT NULL
  • payment_method — varchar2(10) — NOT NULL
  • Payment_amount — vharchar2(100) — NOT NULL
  • ticket_code — varchar2(100) — Foreign key → Untitled.ticket_code — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL
  • purchase_date — VARCHAR(255)
  • mileage_plus — number
  • mileage_minus — number

Untitled6

  • report_Id — number — Primary key — NOT NULL
  • report_title — varchar2(20)
  • report_content — varchar2(20)
  • bike_serial_number — number — Foreign key → bike.bike_serial_number — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL

Untitled7

  • file_id — bigint — Primary key — NOT NULL
  • type — varchar(50) — NOT NULL
  • file — name` — NOT NULL
  • created_at — timestamp — NOT NULL
  • ID — varchar2(100) — Foreign key → member.ID — NOT NULL

Untitled8

  • file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
  • noticeBoard_number — number — Foreign key → manager_board.noticeBoard_number — NOT NULL

Untitled9

  • file_id — bigint — Foreign key → Untitled7.file_id — NOT NULL
  • post_number — number — Foreign key → Untitled2.post_num — NOT NULL

bike

  • bike_serial_number — number — Primary key — NOT NULL
  • Failure — status` — NOT NULL
  • place_serial_number — number — Foreign key → place.place_serial_number — NOT NULL
  • enroll_date — date — NOT NULL

manager_board

  • noticeBoard_number — number — Primary key — NOT NULL
  • title — varchar2(100)
  • post_date — date — NOT NULL
  • content — varchar2(1000) — NOT NULL

member

  • ID — varchar2(100) — Primary key — NOT NULL
  • password — varchar2(100) — NOT NULL
  • name — varchar2(100) — NOT NULL
  • gender — varchar2(10) — NOT NULL
  • age — number — NOT NULL
  • email — varchar2(100) — NOT NULL
  • address — varchar2(100)
  • phone — varchar2(100) — NOT NULL
  • id_enroll_date — date — NOT NULL
  • member_level — varchar2(10) — NOT NULL — 관리자-일반회원 등급으로 구분
  • total — mileage` — NOT NULL
  • Field — VARCHAR(255)

place

  • place_serial_number — number — Primary key — NOT NULL
  • place_name — varchar2(100) — NOT NULL
  • latitude — number — NOT NULL
  • longitude — number — NOT NULL
  • address — varchar2(100) — NOT NULL