YH Team Project

Tables (4)

Board (board)

  • bId (b_id) — number AutoIncrement — Primary key — NOT NULL
  • ID (id2) — number AutoIncrement — Foreign key → Member.ID — NOT NULL
  • bTitle (b_title) — VARCHAR2
  • bDate (b_date) — Date
  • bLike (b_like) — Number

Comment (comment)

  • cId (c_id) — number AutoIncrement — Primary key — NOT NULL
  • bId (b_id) — number AutoIncrement — Foreign key → Board.bId — NOT NULL
  • ID (id2) — number AutoIncrement — Foreign key → Board.ID — NOT NULL
  • cContent (c_content) — VARCHAR2

Emergency Inform (emergency_inform)

  • emerID (emer_id) — number AutoIncrement — Primary key — NOT NULL
  • ID (id2) — number AutoIncrement — Foreign key → Member.ID — NOT NULL
  • emerSituType (emer_situ_type) — VARCHAR2
  • emerGrade (emer_grade) — VARCHAR2
  • emerContent (emer_content) — VARCHAR2
  • emerX (emer_x) — NUMBER
  • emerY (emer_y) — NUMBER
  • emerTime (emer_time) — Date

Member (member)

  • ID (id) — number AutoIncrement — Primary key — NOT NULL
  • mID (m_id) — varchar2
  • mPW (m_pw) — VARCHAR2
  • mName (m_name) — VARCHAR2
  • mGender (m_gender) — VARCHAR2
  • mAddress (m_address) — VARCHAR2
  • mTP (m_tp) — NUMBER
  • mCP (m_cp) — NUMBER