NOERROR ERD

Tables (3)

BOOK_PAY

  • PAY_SEQ — NUMBER — Primary key — NOT NULL
  • PAY_USER_ID — NUMBER
  • PAY_MONEY — NUMBER
  • PAY_TIME — DATE
  • PAY_METHOD — VARCHAR2(30)
  • PAY_DETAIL — VARCHAR2(500)
  • PAY_STATUS — VARCHAR2(30)

BOOK_SOCIALINFO

  • SOCIAL_ID — NUMBER — Primary key — NOT NULL
  • SOCIAL_EMAIL — VARCHAR2(100)
  • SOCIAL_NAME — VARCHAR2(100)
  • SOCIAL_PHONE — VARCHAR2(30)
  • SOCIAL_TOKEN — VARCHAR2(300)
  • SOCIAL_AUTH — CHAR(1)

BOOK_USERINFO

  • USER_ID — NUMBER — Primary key — NOT NULL
  • USER_EMAIL — VARCHAR2(100)
  • USER_PASSWOARD — VARCHAR2(100)
  • USER_NAME — VARCHAR2(100)
  • USER_PHONE — VARCHAR2(20)
  • USER_AUTH — VARCHAR2(100)
  • USER_BIRTH — VARCHAR2(20)
  • USER_ADDRESS — VARCHAR2(200)
  • USER_DELFLAG — VARCHAR2(100)
  • USER_PANALTY — VARCHAR2(100)
  • USER_RENT — CHAR(1)