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